AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N314JLawrence B Botsford · Sanger, TXN314JASharp Jerry L · Georgetown, TXN314JBBratton Johnny B · Williamsport, TNN314KBMatthews Grover C · Hardinsburg, KYN314LARaintree Aviation LLC · Mesa, AZN314MAircraft Partner Holdings Inc Trustee · BerlinN314MFGobel Victor M · White City, ORN314MPTeristar LLC · Lewes, DEN314NFWillis Charlotte Y · Belleview, FLN314PBBledsoe Mark · Saint Charles, ILN314PTStrong Thomas W · Rigby, IDN314PWJ&S Corley LLC · Peoria, AZN314PYKahn William D · Weddington, NCN314REvans Randall B Trustee · Fallon, NVN314RARochester Air Center LLC · Canandaigua, NYN314RSAcorn Mutual Flying Club Inc · Hershey, PAN314RVRegistered aircraftN314SOrem John Marshall · Shallowater, TXN314SAAeryn Innovations LLC · Dallas, TXN314SEZaludek Joseph S · Eugene, ORN314SHGrover Arlan K · Aurora, CON314SRRoesler Scott D · Homer, AKN314SYDeas James A · Independence, ORN314TRShalexco LLC · Salt Lake City, UTN314TSSteele William G · Warrenton, VAN314TTSappa Valley Construction LLC · Oberlin, KSN314UPro Aire Cargo & Consulting Inc · Oshkosh, WIN314YOlson Allen J · Ludington, MIN3150DTransmountain Aviation Inc · Kasilof, AKN3150LS & S Aircraft Inc · El Dorado, ARN3150WRegistration Pending · Olympia, WARegistration pendingN31519Aerobatics Unlimited · Utica, ILN3151DVan Aero LLC · Dover, DEN3151EAviation Capital Management LLC · San Jose, CAN3151FBentley Nicholas Klausing · Reading, PAN3151JStava Robert D · Brainard, NEN3151QRairdan Todd G · Vacaville, CAN3151RBergstrom Danny · Stillwater, MNN3151SThomas Darryl · Belfield, NDN3151XJoseph Stern · Sherman, TXN3151YVert James E · Davison, MIN3151ZOld Crow Flyers LLC · Mooresville, NCN31526Trostel Manfred E · Longboat Key, FLN3152ERegional Medical Consulting Pllc · Mebane, NCN3152FJk Aviation LLC · Warden, WAN3152QFff Aviation LLC · Land O Lakes, FLN3152SDavis Lee W · Burns, ORFirst renewal noticeN3152ZMoultrie Zachariah D M · Grass Valley, CAN31531Storey James F · Gadsden, ALN31532Delaware Valley Aviation Inc · Langhorne, PA
Back to AD 2007-04-19 R1