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.
N26323Peachtree Builders LLC · Waterford, NYN2632BHeubeck Associates Inc · New York, NYN2632CSheldon Benjamin Lloyd · Duck Creek Village, UTN2632FOn Final Holdings LLC · West Olive, MIN2632GHuey James M · Fulton, MOFirst renewal noticeN2632JDevries Mark R · Eagle River, AKN2632PBargabos Richard O · Peterboro, NYN2632WKrapp Transfer · Jamestown, NDN2632YAtp Aircraft 4 LLC · Wilmington, DEN26330Davis Timothy Scott · Lexington Park, MDN26334Mullins Donald · Pounding Mill, VAN26337Munson Andreas C · Seattle, WAN2633CWalusz Bernice J · Linden, NJN2633FYork Greg · Blanco, TXN2633RDevries Mark R · Eagle River, AKN26349Bonnell Corey K · Waxahachie, TXN2634EAzul Services LLC · Bozeman, MTN2634FCockerham Milton D · Gooding, IDN2634MN2634mm LLC · Farmingdale, NYN2634RRichardson Michael T · Inver Grove Hghts, MNN2634WGuerrero Aircraft LLC · Newport, WAN26353Scoggin Gerald W III · Port Saint Lucie, FLN2635BGrimes Jeremy M · Wasilla, AKN2635CMason Gregory J · Rice Lake, WIN2635GStockton Finance Inc · New Braunfels, TXN2635KVerdi Stephen · Newtown, PAN2635PSchuller Henry Michael · Arlington, WAN2635QAir-Mods Flight Academy · Robbinsville, NJN2635RJong Hoon Cho · Rch Palos Vrd, CAN2635WElam Brent R · Woodford, VAN26360Stickney John M · Chapin, SCN26368Parker Dennis A · Charlevoix, MIN2636CSexton David Lee · Barnesville, GAN2636FCernilia James J · Newport Beach, CAN2636GHousken George E · Gardnerville, NVFirst renewal noticeN26370Gv Air Inc · Medford, ORN26379Wings Over Texas Holdings LLC · Denton, TXN2637CSafety In Motion Flight Center Inc · Puyallup, WAN2637DMcanulla Robert · Trabuco Canyon, CAN2637FMccrum James M · Seattle, WAN2637GSalisbury Jonathan T · Seabeck, WAN2637PMurray James A · Wasilla, AKN2637WCox James L · Fort Worth, TXN26380Downey Matthew R · Colorado Springs, CON26384Farley Robert W · Warwick, MAN26385Emerald City Aircraft Leasing Inc · Port Orchard, WAN26387Masco Howard N · Huntsville, ALN26389Wilson Billy Joe · Granite Falls, NCN2638CPickett Joseph C · El Paso, TXN2638GEvans Steven H · Hattiesburg, MS
Back to AD 2007-04-19 R1