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.
N2919ZPankonin Steve B · White City, ORN291ABSerafini Louis · Ringwood, NJN291ACBennett Mark A · Normangee, TXN291BPJackson Jeffrey L · Manchester, TNN291CAMaya Air Services LLC · Lee, NHN291CBCalifornia Baptist University · Riverside, CAN291CMAutorific High Performance Carwash Inc · Roxboro, NCN291DCT G Dunn Plumbing Inc · Hulls Cove, MEN291DMMiller Jerry L · Garrison, NDN291DSPetko James G · Mishawaka, INN291ECElizabeth City State University · Elizabeth City, NCN291FWilliams Joshua B · Reno, NVN291FCKellner Kenneth J · Neenah, WIN291GTNattjat Aviation LLC · El Dorado Hills, CAN291HAChandler Air Service Inc · Chandler, AZN291HPBurke Matthew Joel · Maricopa, AZN291HWMiddle Village Enterprises LLC · Maspeth, NYN291JBSoules William P · Las Cruces, NMN291JDDahapov LLC · Boca Raton, FLN291KFTotal Flight Aircraft Leasing LLC · Apex, NCN291LAPiper 3 LLC · Chestnut Ridge, NYN291LHChristiansen Aviation LLC · Wilmington, DEN291MCGonzalez Joseph III · Saginaw, TXN291MEUnique Educational Experiences · Long Beach, CAN291MGGeorgia Aviation Authority · Eastman, GAN291MKPlane Nonsense Inc · Middletown, DEN291PEPhoenix East Aviation LLC · Daytona Beach, FLN291PSInternational Air Services Inc Trustee · Carson City, NVN291RAParsons Aviation Inc · Wilmington, DEN291RBAbbott Air Inc · Hydro, OKN291RPGtr Aero LLC · Moultonborough, NHN291RVWarped Spoon LLC · Kalispell, MTN291SAWoods Aviation LLC · Kearney, NEN291SGMiller John J · Fairfax, VAN291SPBarr Air Patrol LLC · Mesquite, TXN291TPSparebanc LLC · Appleton, MNN291WCColorado Mesa University · Grand Junction, CON29204Jms Aviation LLC · Waynesville, OHN29209Bas Part Sales LLC · Greeley, CON2920GStevenson Taylor A · Dallas, TXN2920KBowen Kenneth W · Bainbridge Island, WAN2920PErwin Randall · Johnson City, TNN2920RCarboneau Luke · Las Cruces, NMN2920WBrown Jeffrey C · Bozeman, MTN2920YApplegate Susan P · Decatur, TXN2920ZBruch Robert Allen · Roanoke, VAN29210Hawkes Brian R · Hamilton, MTN29215Lzl Aviation LLC · Wilmington, DEN29217Dawson Adam J · Eveleth, MNN29218Israelsen Martin · Santa Rosa Beach, FL
Back to AD 2007-04-19 R1