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.
N461AJohnson James Michael · Mount Pleasant, SCN461ACTucker Gary · Georgetown, TXFirst renewal noticeN461AJRkt Productions · Bristow, VAN461BCB&K Leasing Inc · Nantucket, MAN461BGDangelo John A · Dallas, TXN461CDRiver City Leasing LLC · Lakeville, MNN461CMUniversity Of Central Missouri · Warrensburg, MON461CPCivil Air Patrol · Maxwell Afb, ALN461CTMarkham Reid S Jr · Louisville, KYN461DAGrave Eugene G · Spencer, INN461DKMark Andregg Dds Pc · Tulsa, OKN461DMBryn Jamie P · Dazey, NDN461EMNoll Jason · Geneva, ILN461FAStratus Rr LLC · New Castle, DEN461HHawaii Pacific Aviation Inc · Kailua Kona, HIN461JGGosch Jerry L · Missouri City, TXN461LWBent Douglas G Trustee · Stuart, FLN461PMMcmillion John T Trustee · Grand Marais, MNN461RCElicottero Rosso LLC · Missoula, MTN461RKTolstrup Dustin G · Wasilla, AKN461RMRr&D Lp · Fayetteville, NCN461TJSharmouj Raymound · Christiansted, VIFirst renewal noticeN46200Larsen Delaine E · Wakarusa, INN46201Lakes Area Aviation LLC · Little Falls, MNN46203Avian Leasing LLC · Bremerton, WAN46204Ms Tango LLC · Phoenix, AZN46205Jeanes Michael W · Newbury Park, CAN4620BRucando Matthew P · Eagle River, AKN4620YCenturion Travel LLC · Fort Worth, TXN46210Cloud Dancer Aviation Inc · Deland, FLN46211Carver Clarence K Trustee · Lutz, FLN46214Greaves Ricky W · Arlington, TXN46219Diehl Samuel A · Hamptonville, NCN4621DW Tech Consulting Inc · Wilmington, DEN4621JSudor Janet · Lancaster, PAN4621MBassline Logistics LLC · Watauga, TNN4621QFitzgerald Barry Eugene · Springfield, ILN4621RVides Jose F · La Puente, CAN4621SSlayton Oil Corporation · Roswell, NMN46221Collins Kellie Lynn · Muskegon, MIN46226Tye Darren · Tulia, TXN46227Lindsay Lori K · Kenai, AKN4622AMyers Matthew D · Moody, TXN4622NVmi Flight Co LLC · Roanoke, VAN4622QBas Part Sales LLC · Greeley, CON4622RZimmerschield Paul T · Sedalia, MON46230Owen Collins · Toccoa, GAN46231Hibdon Repair LLC · Grundy Center, IAN4623AHickle William H · Inyokern, CAN4623FHatfield William G · Nunica, MI
Back to AD 2007-04-19 R1