AD 2003-24-13
Registered aircraft · 7,870
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:2003-24-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:2003-24-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:2003-24-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:2003-24-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.
N5205UVoloshin Vitaly Alexandrovich · Seattle, WAN52070Cendejas Agustin · Chino, CAN52072Wicked Wings Aviation LLC · Dover, DEN5208S5fs Aviation LLC · Lewes, DEN5209FMidwest Avtech Inc · South Barrington, ILN5209POliver Dennis L · Williamsburg, IAN520EPMiles In The Sky LLC · Springfield, MON520ERN520er LLC · New Orleans, LAN520FSCloud One Flying Club Inc · Kansas City, MON520KSH2 Link Company · Lewes, DEN520LHH2 Link Co · Lewes, DEN520PLRdp Aviation LLC · Gig Harbor, WAN520WBVan Bortel Aircraft Inc · Arlington, TXN5210AChristiansen Aviation LLC · Wilmington, DEN5210QFortress Group LLC · Thompsons Station, TNN5211VPipe Dream LLC · Stout, OHN52128Glasslane LLC · Wilmington, DEN5212XMoore John S · Strafford, NHN5213FJefferson City Aviation Inc · Jefferson City, MON5213MFlight Training Aircraft LLC · Wilmington, DEN5215JIndigo Air LLC · Newburgh, NYN5216ULeopard Air LLC · Oklahoma City, OKN5218FMacmillan Performance LLC · Torrance, CAN5218UWnc Aviation LLC · Arden, NCN5218YMcintire Aviation LLC · Middletown, DEN5219EUS Department Of Homeland Security · Washington, DCN5219VSkymates Inc · Wilmington, DEN521AFChhh LLC · Raleigh, NCN521CAAftcloud Inc · Ontario, CAN521DBBowling Donald W · Greensburg, INN521DJCuff Ronald J Trustee · Paso Robles, CAN521EPEpic Aviation Inc · New Smyrna Beach, FLN521ER521er LLC · Blaine, MNN521JDH&G Farms Inc · Corcoran, CAN521JTDeralex Airways LLC · Miami, FLN521KSKs Flying Club Inc · Manhattan, KSN521MCBarr Air Patrol LLC · Mesquite, TXN521NDPhoenix East Aviation LLC · Daytona Beach, FLN521SDMedary Aviation LLC · Brookings, SDN521TKCato Air LLC · Wilmington, DEN52208Eastern Kentucky University · Richmond, KYN5220AMarshall Chadwick J · Fort Walton Beach, FLN5222GHanger C16 LLC · Pinckney, MIN52232Mustang Sally Aviation LLC · Camden, SCN5223MGraham Holdings Inc · Atherton, CANon-citizen corporation, flight hours not reportedN5223SFrancis Larry Wayne · Whitewright, TXN52241Christiansen Aviation LLC · Wilmington, DEN5224EFlight Training Aircraft LLC · Wilmington, DEN5224GBank Of Utah Trustee · Salt Lake City, UTN5225LFirst Aero LLC · Edmonds, WA
Back to AD 2003-24-13