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.
N375JSScharff John M · Clinton, ILN375JTD2 Aviation LLC · Chesterfield, MON375JWPanthers Aviation LLC · Pikeville, KYN375KSchlesinger Dmitri P · Los Angeles, CAN375KMSelchow Gene R · Machesney Park, ILN375LMiroyan Robert Trustee · San Jose, CAN375MASteinhardt Clark R Jr · Green Bay, WIN375MKIntegrity S&J Properties LLC · Amarillo, TXN375PWRyan Adrian B · Anchorage, AKN375RHyannis Air Service Inc DBA · Hyannis, MAN375RBMarinella Leasing LLC · Chandler, AZN375TJohnson Nick H · Houston, TXN375UMAlaskan Outhouse Adventures LLC · Big Lake, AKN375WVictory Holdings LLC · Anacortes, WAN375YVBisono Pablo R · San Juan, PRN3760BSavage David C · Austin, TXN3760PAltitude Unlimited Inc · Lewes, DEN3760TArizaga Diana M · Mamaroneck, NYN3760WTonini Ryan · Huntsville, ALN3760YHarris Stephen T · Williamstown, KYN3761PSky Rollers LLC · Merritt Island, FLN3761THupp Michael A · Marietta, OHN3761ZLazenby Gary M · Grangeville, IDN3762NPost Timothy · Hillsdale, MIN3762PMorrison Rodney R · Hot Springs, ARN3762QHarris Randal Glenn · Sedona, AZN3762TBenson Robert W · Iowa Park, TXN3762ZChapman Stuart M · Vernon, CON3763FSmith Herbert L · Brandon, MSN3763KRyback Andrew · Ocala, FLN3763QOrr Robert · San Clemente, CAN3763TGorey Chase · Saint Augustine, FLN3763UHunter James C · Shelton, WAN3763WDaise Nicklaus J · West Chester, PAN3764CCopeland Gary L · Williamsburg, MIN3764PValdes Omar F · Huntington Park, CAN3764ZDelph Timothy M · Wasilla, AKN3765FSalton Robert L · Charlotte, NCN3765QTonry Richard Martin · Georgetown, TXN3765SKennedy Patrick M · Great Barrington, MAN3765THakanson Paul J · Norway, MEN3765WMazzochi James A · Hilton Head Island, SCN3765YBott David F · Yukon, OKN3765ZKrumm Arno Hermann · Anchorage, AKN3766DFree Range LLC · Missoula, MTN3766YPyanov Mark · Clinton, MSN37674Bendure Ryan R · Brighton, CON3767PStrutzenberg Keith W Trustee · Chandler, AZN3767TFd Equipment Rentals · Sacramento, CAN37687Williams Lee E · Oshoto, WY
Back to AD 2007-04-19 R1