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.
N4824GHickman Robert B · La Follette, TNN4824SWilly Jack LLC · Wickenburg, AZN4825ATodd Gary W · Rogers, OHN4825DHitec Construction Services Inc · Lincoln, CAN4825EParis Enterprises LLC · Atlanta, GAN4825NBlue 79 LLC · Loogootee, INN4825YHall William B · Vincentown, NJN4826DTurbine Training Center Inc · Manhattan, KSN4826SQuill Sean · Hadley, MAN4826TSundance Air Services Inc · Alameda, CAN4827DWebber David A · Delta Junction, AKN4827LDes Moines Flying Club · Indianola, IAN4827PCarlson Chris · Redwood City, CAN4827SMckemy Michael L · Joppa, MDN4827UHagen Rainer · Irving, TXN4827YThief River Aviation Inc · Thief River Falls, MNN4828DNisbet William T · Driggs, IDN4828HWilson Aviation Club LLC · Wilmington, DEN4828KFlywerx LLC · Anchor Point, AKN4828LMcmordie Frank F IV · Dallas, TXN4828PFlying Nam LLC · Sheridan, WYN4828SPuerto Rico Aircraft Leasing Corp · Ceiba, PRN4828TSun Star Holdings LLC · Binghamton, NYN4829GSoaring Raven LLC · Seattle, WAN4829JMidwest Aircraft Services Inc · Wilmington, DEN4829KCanal Flight LLC · Portland, ORN4829LHoughton Robert E · North Ferrisburgh, VTN4829NKcj Fly LLC · Fuquay Varina, NCN4829RThomas Michael W · Prescott, WAN4829TMaples David R · Diamondhead, MSN482AArcher Aircraft LLC · Wilmington, DEN482ACClarke Jonathan Eric · Eustace, TXN482AMWarner Robins Air Service · Cochran, GAN482ASPlatt Drey D · Sahuarita, AZN482CACivil Air Patrol · Maxwell Afb, ALN482CCMitchell Timothy K · Dunnellon, FLN482CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN482CPCivil Air Patrol · Montgomery, ALN482CSTextron Aviation Inc · Wichita, KSN482DTCavorite Aviation LLC · Lehi, UTN482EHb Coco & Company · Gonzales, TXN482EJDavis Douglas L · Everson, WAN482EREmbry-Riddle Aeronautical University · Daytona Beach, FLN482FLJacobs Mark W · Browning, MTN482KBBethune Kenneth · Huntsville, ALN482MBSmith Thomas W · Wall Township, NJN482NBCline Braxton L · Wasilla, AKN482PSinsaja Holdings LLC · Sheridan, WYN482TWT34 Mentor LLC · Saint Joseph, ILN4830ARenick Tyler Cain · Wichita Falls, TX
Back to AD 2007-04-19 R1