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.
N5065ERickman Wanda M · Absarokee, MTN5065PVeal Ted W · Homer, AKN5065RZ J Express LLC · Lewes, DEN5065WAddai Emmanuel · Cincinnati, OHN5065XWallace Aviation Inc · Wallace, NEN5065ZFour Guys Flying LLC · Tunica, MSN5066DCurry Timothy S · Salisbury, MDN5066KShiner Mach LLC · Kingwood, TXN5066LMeise Fred W · Moses Lake, WAN5066PDelaware Aviation LLC · Sidney, NYN5066QChristen Darryl K · Houma, LAN5066RBurke William M · Norwalk, CTN5066TLee Miesner Aviation LLC · Park Hills, MON5066VAction Center LLC · Morgan, UTN5066XChandelle LLC · Chelsea, ALN50678Nieslanik Diane M · Cokeville, WYN5067ERickenbach Rodd L Trustee · Denver, CON5067GJones Jerry E · Pocahontas, ARN5067HSanders Flight Training Center Inc · Jasper, ALN5067KN5067k LLC · Lenexa, KSN5067SSinatsch Christian C · Saint Augustine, FLN5067VKampert Keith Wayne Jr · Ninety Six, SCN5067WFiore Christopher · Forked River, NJN5067XMiller Johnny D · Rhome, TXN5068DGeorge Delmond L · Dewitt, ARN5068GScaled Composites LLC · Mojave, CAN5068LPark Jalynn C · Blacksville, WVN5068QManis Joe Dan · Laurinburg, NCN5068TAbc Leasing Inc · Oakdale, LAN5068WJankord Emery T II · Ballston Lake, NYN5068XNobles Ronny · Live Oak, FLN50693Griffing Flying Service Inc · Port Clinton, OHN5069GLeverich J E · Pampa, TXN5069HNehring Curtis A · Goleta, CAN5069JWestfield Public Schools · Westfield, MAN5069SMccarron Michael · Cary, ILN5069UGoff Bayou LLC · Shelby, MSN5069VDieter Damian D · South Bend, INN5069WNelson Stephen A · Milaca, MNN5069XWright Bruce M · Rosharon, TXN506ATClinthorne David W · Fredericksburg, VAN506CDAloha Helicopter Tours LLC · Lihue, HIN506CXEagle Helicopters LLC · Beulah, NDN506DBMerlin Labs Inc · Mojave, CAN506DCCombs Dale B · Pleasant Grove, UTN506DRSol Aerial Surveys LLC · Las Vegas, NVN506DSFlight Level 510 LLC · El Dorado Hills, CAN506EREmbry-Riddle Aeronautical University Inc · Prescott, AZN506GLKutschera Theodore C III · Callicoon, NYN506HPPedden Patrick M · Fort Wayne, IN
Back to AD 2007-04-19 R1