AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N278KERotor Technologies Inc · Nashua, NHN278MGGeorgia Aviation Authority · Eastman, GAN278MHSimms Hospitality Group LLC · El Segundo, CAN278NDRegistered aircraftN278RCSanborn Map Company Inc · Colorado Springs, CON278SHSmith Kenneth S Jr · Uvalde, TXN278SJOrr George Douglas · Hood River, ORN278SPSvetful Aviation LLC · Camden, SCN2790WMoondogger LLC · Yakima, WAN27917Warbelows Air Ventures Inc · Fairbanks, AKN27918Reneau Thomas E · Midland, TXN2791WToothman John · Fairmont, WVN2793WSchneider Aerial Inc · Rugby, NDN2793Y3y Leasing LLC · Englewood, CON2796WPennington Jeffrey B · Wrightwood, CAN2797WWebb John H Jr · Paulding, OHN27987Alaska Air Taxi LLC · Anchorage, AKN27989Csc Delaware Trust Co Trustee · Wilmington, DEN2798CStone Aviation LLC · Sacramento, CAN2798WSb Enterprise LLC · Marshall, TXN27990Aztec Worldwide Airlines Inc · Wilmington, DEN279AGWings Over Texas Holdings LLC · Denton, TXN279CGDelaware State University · Dover, DEN279JHBravo Zulu Aviators LLC · Midland, TXN279LGAltius Aviation LLC · Syracuse, NYN279MASd Aviation LLC · Danville, CAN279MGGeorgia Aviation Authority · Eastman, GAN279NDSowela Technical Community College · Lake Charles, LAN279PWMauck Ryan S Trustee · Bend, ORN279WYMccarty David · Baker City, ORN27AMThom Jacob D · Wasilla, AKN27AUAndrews University · Berrien Springs, MIN27AZGilbert John K · Austin, TXN27BEAir N Nautical LLC · Kalispell, MTN27BLFairmont State University · Fairmont, WVN27BRLarson Allen L · Capron, ILN27CYSale Reported · Hastings, FLSale reportedN27DASiewruk Cameron M · Stuart, FLN27DRN504fl LLC · Killeen, TXN27DVDodson International Parts Inc · Rantoul, KSN27EKPrecision Aviation Training LLC · Newberg, ORN27FMGogoplex LLC · Wilmington, DEN27GSMazzola Michael · Baton Rouge, LAN27GWWatson Gary R · Modesto, CAN27GZKelly Kristofor · Belton, TXN27HCCranston Courtland L · Santa Rosa, CAN27HPTrinair Aviation LLC · Hampshire, ILN27HRRemer Herbert I · Punta Gorda, FLN27HUOlson Dorian J · Lake Park, MNN27HWJacobs Jim · Great Barrington, MA
Back to AD 2006-10-21