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.
N383PSUtah State University · Logan, UTN383PTFf22 LLC · Scottsdale, AZN383SA86 Malibu LLC · Fort Worth, TXN383SCCohan Scott L · Roseburg, ORN383SPKv Helicopters LLC · Lititz, PAN383TCSpengler Raymond Francis Jr · Longview, TXN383TTWestwood Aircraft LLC · Asheville, NCN383TYCrawford Randall Jay · Jal, NMN38409Straub Craig W · San Martin, CAN3840DLangbehn Lee W · Great Falls, MTN3840NDmitrich Michael A · Pleasant Grove, UTN3840PPiper Aviation Museum Foundation · Lock Haven, PAN3840USomerset Aviation LLC · Gadsden, ALN3840YBurrill Resources Inc · Medford, ORN3840ZWorley Donald E Jr · Rocky Mount, VAN38411N38411 LLC · Bellevue, WAN38412Rekaa Enterprises LLC · Paragould, ARN3841TN3841t Lk Aircraft Holdings LLC · Wheeling, ILN3841WHirschler Steven · Big Bear Lake, CAN3841XJ W Faherty Inc · Apple Valley, CAN3841ZOcean Aerial Ads Inc · Ocean City, MDN38421Sale Reported · Ephrata, WASale reported, pending cancellationN3842PJohnson Carroll J · Tok, AKN3842UBezet Danny · Comfort, TXN3842VN3842v LLC · Wainscott, NYN3842WAnderson David A · Omaha, NEN3842YCole Scott A · Rockford, MIN3842ZWilliams Sunita L · Houston, TXN38430Vp Aviation Inc · Bloomington, INN38433Global Aviation Corp · Farmingdale, NYN38434Wheeler Jeffrey Scott · Hampstead, NCN3843DNichols Bryan M · Canute, OKN3843GBash Dennis W Jr · Wasilla, AKN3843SSky West Aviation Inc Trustee · Albuquerque, NMN3843WStrong Jason · Agency, MON38448Orphans Hands Inc · Clinton, TNN3844CMansfield Heliflight Inc · Milton, VTN3844GLandvalue Management LLC · Fresno, CAN3844KSymonds Gregory S · Old Lyme, CTN3844MN3844m LLC · New Canaan, CTN3844NKlauschie David A · Papillion, NEN3844QSmtm Holdings Inc · Wilmington, DEN3844YManarin Roland R · Lakemont, GAN38457Registration Pending · Phoenix, AZRegistration pendingN3845DTeam Gateway LLC · Lewes, DEN3845LDonq LLC · Hartford, CTN3845QMacon Flying Club Inc · Macon, MON3845TBakrevski Lupcho · Valparaiso, INN3845XHaas James D · Frisco, TXN3845Y1st Due Emergency Response Solutions LLC · Bartlett, KS
Back to AD 2007-04-19 R1