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.
N304CGVan Bortel Aircraft Inc · Arlington, TXN304CPCivil Air Patrol · Maxwell Afb, ALN304DB4db Leasing LLC · Englewood, CON304DFDevils Lake Aero Repair Inc · Devils Lake, NDN304HGGeorgia Aviation Authority · Eastman, GAN304JEEiler John Edward · Jackson, MIN304JTCentral Airlines Inc · Overland Park, KSN304MWJp Air LLC · Kalispell, MTN304PRRedlands Air And Road Museum · Yucaipa, CAN304QAAltus Aviation Managment · Las Vegas, NVNon-citizen corporation, flight hours not reportedN304RABrendle Robert E · Forest City, NCN304RQSpitzer Helicopter LLC · Wilmington, DEN304SFPerle Mark · Plainfield, ILN304WHLone Beech Enterprises LLC · Peachtree City, GAN304ZBrickley Glendon R · Greenwood, SCN305Keene Keith L · Crosby, TXN30500Hansen Larry A · Waverly, IAN30502James A Caufield · King City, ORN3050EDsi Limited Liability Corp · Blue Ridge, VAN3050JRegistration Pending · Lake Frederick, VARegistration pendingN3050LMadison Mitchell · Guthrie, OKN3050NLuttrell Robert E III · Mckinney, TXN3050YSmith Adam M · Holloman Afb, NMN30514S&S Aircraft Inc · Bennington, VTN30516J A Sutherland Inc · Ukiah, CAN3051AHigby James E Jr · Frederick, CON3051CMedic Choppers LLC · Springdale, ARN3051EBellingham Aviation Services LLC · Bellingham, WAN3051NOdendaal Willem G · Blacksburg, VAN3051UPierson William Grant · Kerrville, TXN3051WWong Direction LLC · Lantana, TXN30521Sale Reported · New Bern, NCSale reported, pending cancellationN30522Colvin Buster · Big Cabin, OKN30524Christianson Jarrett I · Gilbert, AZN30525Johnson Monte W · La Porte, INN30527Boone Fliers LLC · Boone, IAN3052ACallis Edward Neill · Turlock, CAN3052BRegistration Pending · Gallatin Gateway, MTRegistration pendingN3052DAirline Transport Professionals Corp Of USA · Wilmington, DEN3052ERivers Edge Enterprises LLC · Nebraska City, NEN3052FHofer Belik Colleen J · Sawyer, NDN3052SSanchez Donoso David · Miami, FLN3052XJc Flight Inc · Wilmington, DEN3052YPingston Anthony · Plymouth, MIN3052ZSummer Aviation LLC · Eden Prairie, MNN30530Banegas Jose C Zankiz · Fort Myers, FLN30535Terrell Anthony K · Iowa Park, TXN3053ANorris T Mark · Tuscaloosa, ALN3053ECharles City Aeronautics Inc · Charles City, IAN3053FBirkhold Craig Alan · Napoleon, OH
Back to AD 2007-04-19 R1