AD 96-10-01 R1
Registered aircraft · 8,139
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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.
N7430WI Was Inverted LLC · Fort Myers, FLN7431WKonkoi Roger E · Lumberton, NCN7432RHeil Dan M · Hooker, OKN7432WSheppardfox LLC · Germantown, TNN7433RValiair Lc Trustee · Casper, WYN7433WWalls Andrew A · South Ozone Park, NYN7434RMyers Lisa · Sandpoint, IDN7434WCarolina Clouds LLC · Dover, DEN7435WStanley Thomas Russell · Brighton, CON7437WCrfs LLC · Lakeville, PAN7438ROhman Mikael · Watonga, OKN7438WRamunni Andrew · Medina, OHN7439RVetter Aviation Interests LLC · Lakeville, MNN7439WLawrence Nelson D · Rushville, MON743CMBach Samuel A · Marshall, TXN7440WMorsi Sameh M · Pomona, CAN7442WDenney David L · Oak Grove, ORN7443RClarkson Brett D · Stuarts Draft, VAN7444RMarchionda Bruce · Sherman, TXN7444WMedia Stew LLC · Carson City, NVN7445WArola Anthony L · Tacoma, WAN7446REckert Travis R · Texarkana, TXN7447RCompo John · Essex Junction, VTN7448RCraddock Ellis G · Colorado Springs, CON7448WBoyce Gillis · Savannah, TNN7449WMutch Robert E · Barrington, NHN744JNAvia Flight Academy LLC · Stratford, CTN7450WCreager Scott L · Visalia, CAN7451WSamson Ag Flying LLC · Wilmington, DEN7454WPorter Robert D · Manchester, TNN7455RMcanelly Anthony J · Maricopa, AZN7455WNicolai Tim A · Brandon, SDN7457RFoster Adam W · Midland, TXN7457WNilsson Tim E · Yreka, CAN7458WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN7461RIngram John · Tulsa, OKN7461WSdflysc LLC · Mauldin, SCN7462WResidential Inspection Services Inc · Sun City Center, FLN7463RBrezina Douglas · Hines, ILN7463WMarschall Travis T · Culver, INN7464WBabcock Wayne N Trustee · Albuquerque, NMN7466WCooper Tracy V · Little Rock, ARN7467RGee Greg · Los Angeles, CAN7467WPlane Krazy LLC · Edina, MON7469WIshii Kanji · Brooklyn, NYN7470SNorton Jeffrey N · Greeley, CON7471RBalderas Jose Aaron Jr · Mission, TXN7471VCollins Ronald Rs · Rutledge, TNN7471WRegistered aircraftN7472RSouthern Jeffrey · Rayville, LA
Back to AD 96-10-01 R1