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.
N38357Carr Mark · Wshngtn Ct Hs, OHN3835CPreferred Airparts LLC · Apple Creek, OHN3835THuber Charles H · Medina, OHN3835VJones Scott L · Hilliard, OHN3835YCarlton Jeffery G · Great Falls, MTN38368Dubisar Milo Richard · Redmond, ORN3836CAdvanced Airways Inc · Loxahatchee, FLN3836KValarchi Air Aviation LLC · Lewes, DEN3836WOconnell Richard M · Dothan, ALN3836ZTroutman Charles W · Lincoln City, ORN38373Outbound Aviation LLC · Dover, DEN3837DCameron Russell A · Fort Benton, MTN3837EPiper Aircraft Inc · Vero Beach, FLN3837PPlancich Don A · Sterling, AKN3837QBaja Guided Tripps LLC · Grand Lake Stream, MEN3837TRemsberg Charles · University Place, WAN3837WWardlay Farms And Ranches Inc · Grandview, TXN3837YRounds Chris · Waller, TXN3837ZTroutman Charles Wayne · Lincoln City, ORN38382Syracuse Aviation LLC · Cicero, NYN38388Hosanna Industries Inc · Gibsonia, PAN3838GGolden Eagle Outfitters Inc · Delta Junction, AKN3838PArlins Aircraft Service Inc · Belgrade, MTN3838TFundamentals Aircraft Leasing LLC · Erie, PAN3838XHolzman Douglas S · Hood River, ORN3838ZWoldow Fredric A · Morton, ILN38394Wall Jeffrey L · Goffstown, NHN3839DHot Rod Aviation LLC · Fayetteville, ARN3839LFlight School Of Gwinnett · Lawrenceville, GAN3839PMorris Equipment LLC · Yuma, AZN3839RChad Gunter Enterprises LLC · Albany, GAN3839SBailey Glenn K · Englewood, CON3839TN3839t LLC · Copley, OHN3839XMigliaccio Vicki Trustee · Idabel, OKN3839ZPrax Philip G · Fairbanks, AKFirst renewal noticeN383BHAero Aircraft 13 LLC · Jacksonville, FLN383CCWiplinger Charles · Inver Grove, MNN383DDawson Jamie S · Celina, TXN383DANew Mexico Flying Eagle Inc · Tucson, AZN383DCDyncorp International Inc · Mcclellan, CAN383DFDream Flight LLC · Westminster, MDN383GArcher Aero LLC · Wilmington, DEN383HRJirak Daniel L · Wasilla, AKN383KSchirmer Brandon M · Batesville, TXN383KDT-6 LLC · Wilmington, DEN383MAVandenberg Herbert F · Ruston, LAN383MEParlu Ventures LLC · Eagles Mere, PAN383MGMissionary Air Group · Burlington, NCN383NDUniversity Of North Dakota · Grand Forks, NDN383PLambe Clarence Jr · Kernersville, NC
Back to AD 2007-04-19 R1