AD 2000-18-53
Registered aircraft · 45,248
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:2000-18-53')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-18-53')
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:2000-18-53') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-18-53') 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.
N106RMArmstrong Ronald W · Brownsville, TXN106RRC2 Holdings 8 LLC · Chesapeake, VAN106SMMorris Geoffrey J · Henderson, NVN106TLBurton David H · Redlands, CAN106TUDesmit Matthew L · Centerton, ARN106WTSchafer Timothy · Soldotna, AKN1070BCurtis Julia A · Holladay, UTN1070LWilliams Barret G · Homer, AKN1071LGrand Seaplanes LLC · Broken Arrow, OKN1071XPeter Prince Aviation Center LLC · Milton, FLN1072ESabbatino Robert F · New Milford, CTN1072LTorres Ramon Armando · Mulberry, FLN1072QCoastal Air Inc · Groton, CTN1072YRyan Aaron · Wichita Falls, TXN1073FFlydreams Aircraft Group Inc · Fort Lauderdale, FLN1073LDesert Fish Aviation LLC · Queen Creek, AZN1073XAustin Arrows Inc · Austin, TXN1074CZata Group LLC · North Little Rock, ARN1074TIowa Lakes Community College · Estherville, IAN1074XKelley Air LLC · Milford, MIN1075LElsner Henry J · Greensboro, NCN1075MDewitt Scott C · Corpus Christi, TXFirst renewal noticeN1076ATri City Airframe LLC · Kalispell, MTN1076XMarston Lester J · Ukiah, CAN1077XJny LLC · Riverview, FLN1078MGeorge Gary D · Humble, TXN1078UHigh Flight Academy LLC · Allison Park, PAN1079JElmore Danny W · Othello, WAN1079LTradewinds Aero Group LLC · Sarasota, FLN1079MGeneral Aviation LLC · Henderson, NVN1079YBoyer Jerry D · Monument, ORN107AFKummer Michael · Floyd'S Knobs, INN107AKLazzaro Chris C · Solvang, CAN107BAFairmont State University · Fairmont, WVN107BJJanowsky Bruce G · Lakewood, NYN107CGColon Orlando · San Juan, PRN107DSweeney Edward C Jr · Parrish, FLN107ESWalpole John W · Iola, TXN107JDDhall Sanjay · Canton, MIN107KPPeterman Keith A · Salinas, CAN107MRMeriden Aviation Center LLC · Meriden, CTN107MSJprg Aviation Inc · Orlando, FLN107NFratti Robert B · Nampa, IDN107NDN107nd LLC · Wilmington, DEN107PAPacific Fleet Aviation LLC · Rochester, NYN107PFConant Dakotah · Ocala, FLN107RARl Aviation LLC · Miami, FLN107RFStevens Matthew S · Penn Yan, NYN107RHHenderson Robert T Jr · Sunny Isles Beach, FLN107RVRegistered aircraft
Back to AD 2000-18-53