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.
N55051Wings Over Texas Holdings LLC · Denton, TXN55055Martan LLC · Kansas City, MON55057Smooth Air LLC · Churubusco, INN55058Eggensberger Edmund G · Simpsonville, SCN5505DMolloy Mark E · Waxahachie, TXFirst renewal noticeN5505FSerafinowicz Ronald P · Gilbert, AZN5505HKupferschmidt W Alan Trustee · Lake Elmo, MNN5505LRegistration Pending · Saint Johns, FLRegistration pendingN5505MCapozzi Eugene L · Kalispell, MTN5505PLandmann Ryan J · Fort Walton Beach, FLN5505QReynolds C J · Cornelius, NCN5505UPaper Plane Aviation LLC · Avon Park, FLN5505WPerez Daniel E · Parsons, KSN55064Western Skyways Inc · Montrose, CON55065Lynch Timothy B · Aguadilla, PRN55066Premier Capital Enterprises LLC · Hurricane, UTN55067Hinsch Delano G · Larchwood, IAN55069Tre Aviation Corp · Wilmington, DEN5506DGarrison John P · Temple, TXN5506JSoaring For Christ LLC · Big Lake, AKN5506LKoster Michael Richard · Plano, TXN5506MCloud Kicker Aviation LLC · Kalamazoo, MIN5506UHumberto Moreno · Mulberry, FLN5506WMchatton Dret A · Redding, CAN5506ZOakcrest Management Inc · Brownsville, TXN55075Paris Air Inc · Vero Beach, FLN55078Tiritilli Robert · Mission Viejo, CAN5507LFletcher Alex J · Weston, WIN5507MVasenden Arnold V · Midlothian, TXN5507PMccleskey Nicholas J · Mcminnville, ORN5507WBurnett Fred · Greenbrier, ARN55080Keath Brian S · Kansas City, MON55087Fosso Christopher M · Glendale, AZN5508BBohner Richard A · Pls Vrds Est, CAN5508JPaetzold Larry E · Brownwood, TXN5508LDe Lint Marcus W · Cove, ORN5508QSchmidt James A · Richmond, VAN5508SKimmel Frank S III · Greenwood, MSN5508WEkkel Bob J · Newaygo, MIN55094Remedy Aviation LLC · Langford, SDN55096Robinson Jeffrey M · Scottsboro, ALN5509BKorn Antony · Chehalis, WAN5509FAhs Aero LLC · Leo, INN5509JJet Air Inc · Iowa City, IAN5509QCarlson Jeremy Nathaniel · Arnold, CAN5509WKitts John L · New Braunfels, TXN550AFAtm One Inc · Tulsa, OKN550BNAllen Anne · Huntsville, TXN550BRF P And P I Enterprises Inc · Oceanside, CAN550BZRoswell James M · Stuart, FL
Back to AD 2007-04-19 R1