AD 2012-10-13
Registered aircraft · 13,306
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N371PMElias Miguel A · Kenner, LAN371SLOrnelas Sergio L · Santa Teresa, NMN371STSierra Aviation LLC · Fort Lauderdale, FLN37236Nay Richard B · Gunnison, UTN37268H & S Aircraft LLC · Lewes, DEN37285Java Air LLC · Visalia, CAN372CCLemieux Kenneth G · Oneida, TNN372FCHeartland Aviation Inc · Alliance, NEN372LFShoemaker William · Manns Choice, PAN372WTCirrus Design Corp · Duluth, MNN37302Elrod Jason A · Seattle, WAN37306Frescomar USA LLC · Miami, FLN37315Atlantic Coast Contractors Inc · Denver, NCN3731GMaxwell Truck & Equipment LLC · State College, PAN37343Bearings & Belts LLC · Carlsbad, NMN37356Congregation Rosh Hagivah Inc · Waterbury, CTN37360Tkn Holdings LLC · Pima, AZN3737Qualitair LLC · MichelstadtN37376Huntley Storage Units LLC · Billings, MTN373ARPaul Brightwell Dirtworks Inc · Springer, OKN373BBSchackel Shacks LLC · Durango, CON373CDKnight Douglas G · Bend, ORN373DHigh Flight Baron LLC · Holland, MIN373DSRegistered aircraftN373ERStx Aviation LLC · Fresno, CAN373MCKenmore Crew Leasing Inc Trustee · Bellingham, WAN373PJRock Creek Corp · Henderson, NVN373RWCjcat LLC · Sugar Land, TXN373SRSummer Dog LLC · Greenwich, CTN373STLassen Peter C · Ventura, CAN37402Viking Construction Inc · Hayden Lake, IDN3745PRiviera Aircraft Inc · Lewes, DEN3747CS I Air Inc · Dover, DEN3747TAir Force One LLC · Coral Springs, FLN374CDN374cd LLC · Goffstown, NHN374RLDeep Blue Spring LLC · Doral, FLN374TTTyphoon Holdings LLC · Valdosta, GAN374WHLr Freedom Air LLC · Tallahassee, FLN3752CMiller Robert G · Clear Lake, IAN3758CDodson International Parts Inc · Rantoul, KSN375AJGolden Calf Company LLC · Bloomer, WIN375BMBlotsky Jim · Fargo, NDN375CDAtlantic Marine Construction Co Inc · Virginia Beach, VAN375CWN375cw LLC · Fort Smith, ARFirst renewal noticeN375DBEight Aviation LLC · Greenwood Village, CON375JWPanthers Aviation LLC · Pikeville, KYN375MF5k Management LLC · Burnet, TXN375MJJerez Mario · Coral Gables, FLN375MTVan Bortel Aircraft Inc · Arlington, TXN375NDInsuring That Pigs Can Fly LLC · Tyrone, GA
Back to AD 2012-10-13