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.
N2163FSkywarrior Flight Training Inc · Pensacola, FLN2163GWilson Willard III · Cannon Falls, MNN2163JPortland Police Bureau · Portland, ORN2163WBetancourt Jorge · Bowling Green, OHN2164GAulton New Energy Inc · Monterey, CAN21653Skyhawk Holdings LLC · Waco, TXN2165BCondor LLC · Cumberland, RIN2165HQuin Air Inc · Shreveport, LAN2165KAustin David · Cypress, TXN2165WHarrison Dan H · Englewood, FLN21662Smedley Jonathan G · Leander, TXN2166BScroggs Ross A · Locust Grove, GAN2166LNefc Inc · North Andover, MAN21670Kingsky Flight Academy LLC · Lakeland, FLN2167ADelaware Valley Aviation Inc · Langhorne, PAN2167CStarkys Equipment Leasing LLC · Manchester, MIN2167KTurner Tim R · San Angelo, TXN2167TKissi Ernest · New Britain, CTN21683Flying H Inc · Hoxie, KSN2168BBonjour Hugo E · Houston, TXN2168DSpartan Education LLC · Tulsa, OKN2168FDean William R · Webster Springs, WVN2168JAirgus LLC · Henderson, NVN2168KLj Dakota LLC · Berkeley Heights, NJN2168TGlass Kelly R · Jonesborough, TNN2168UMattingly Adam M · Festus, MON21692Knife Edge LLC · Daytona Beach, FLN2169CAddison Jeffery A · Lafayette, LAN2169FBrolan Aviation LLC · Kansas City, MON216BCBell Wendell D · Littlerock, WAN216CACivil Air Patrol · Maxwell Afb, ALN216DBKruse Adam L · Weiser, IDN216DCDornink Steven R · Birchwood, WIN216FWAtp Aircraft 2 LLC · Wilmington, DEN216HTHalstead Edwin R · Tucson, AZN216JARuble Howard L Jr · Spartanburg, SCN216JKKelly James C Jr · Bonaire, GAN216KUS Dept Of The Interior · Boise, IDN216KKKleszcz Kenneth A · Wethersfield, CTN216KWCheron LLC · Stuart, FLN216LTWingsleasing LLC · Wichita, KSN216MAPatriot Flight LLC · Bartlesville, OKN216MPPurifoy John B · Colleyville, TXN216PRegistration Pending · Lincoln, ILRegistration pendingN216PHHunt Peter J · Clearwater Beach, FLN216PWPapa Whiskey LLC · Chicago, ILN216RSShumaker Robert H · Fairfax Station, VAN216SBMorotti John M · Las Vegas, NVN216SPNavy Annapolis Flight Center Inc · Edgewater, MDN216SRRegistration Pending · Bulverde, TXRegistration pending
Back to AD 2006-10-21