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.
N3733YHolliday Ivan Scott · Poplarville, MSN37343Bearings & Belts LLC · Carlsbad, NMN3734DVessey William M · Yuma, AZN3734LBertrand Todd A · Anchorage, AKN3734PHamilton Richard L · Monticello, FLN3734QInternational Aviation Industries LLC · Kalispell, MTN3734UDaricl LLC · Shoreham, NYN3734XTechnical Education Services Inc · Virginia Beach, VAN37350Price Brenda · Poplar Bluff, MON37356Congregation Rosh Hagivah Inc · Waterbury, CTN3735BBas Part Sales LLC · Greeley, CON3735TGarner Brian J · Bluffdale, UTN3735XMcmanus Edwin · Austin, TXN37360Tkn Holdings LLC · Pima, AZN3736DRodriguez Alberto R · San Juan, PRN3736KBloom Cory G · Indianola, IAN3736PKelly Larry M · Alexander City, ALN3736TVelivis Bernard K · Hollis, NHN3736UDelong Don R · Wheeler, MIN3736WLarsen Christopher R · West Melbourne, FLN3736XSmith William C · San Antonio, TXN3737Qualitair LLC · MichelstadtN37376Huntley Storage Units LLC · Billings, MTN3737KCavanaugh Kirk M Trustee · Homer Glen, ILN3737LClark Julie E · Cameron Park, CAN3737MMathur Arvind Kishore · Hemet, CAN3737TKenny David Jack · Frederick, MDN3737UAirria Holdings LLC · BerlinN3737WVoss James S · Soldotna, AKN3738DHall Chris S · Garden City, MON3738MAnsell Nathan D · Mukwonago, WIN3738QLumpkin Ed · Rosie, ARN3738RHumphries Scott A · Houston, TXN3738WNewton Machine Co Inc · Charlotte, NCN3738YAirborne Solutions Group LLC · Dayton, OHN3738ZAma LLC · Port Orange, FLN3739BD & G Properties Troy LLC · Troy, ALN3739DBodie Aviation Ltd · Laporte, CON3739QN3739q LLC · Colleyville, TXFirst renewal noticeN3739UYown Inc · Ethridge, MTN3739WPacific Gold Aviation Association · Roseville, CAN3739YCessna 210 LLC · Ogden, UTN373ARPaul Brightwell Dirtworks Inc · Springer, OKN373BGSynergy International · Oakdale, CAN373BSPenn Mitchell · Poplar Bluff, MON373CACoco Aircraft Inc · Merritt Island, FLN373CDKnight Douglas G · Bend, ORN373CPCivil Air Patrol · Maxwell Afb, ALN373DHigh Flight Baron LLC · Holland, MIN373DC3d Capture LLC · Lumberton, TX
Back to AD 2007-04-19 R1