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.
N241BDHanus David S · Mound, MNN241DKSale Reported · Wilmington, DESale reportedN241EPEpic Aviation Inc · New Smyrna Beach, FLN241GSmith Albert K · Pentwater, MIN241GTBroshchan Ruslan A · Jackson, MSN241HBEngelmann Christopher · Mayer, MNN241HCButcher Robert E · Friendswood, TXN241JAHot Wings Aviation LLC · Indianapolis, INN241JESmedshammer Paul J · Petaluma, CAN241KRMako Offshore Exploration Inc · Pagosa Springs, CON241MAKim Sung Su Trustee · Upland, CAN241ME#430b LLC · Bruce Township, MIN241PArnston Ranch Inc · Circle, MTN241PAHilow LLC · Woodbury, MNN241PBTranstek International Inc · Deerfield, ILN241RBJankowski Richard S · Shenandoah, TXN241RGAmerican Patrols Inc · Midland, TXN241TFAir Fleet Holdings LLC · Missoula, MTN241TNWilmoth Matthew L · Traverse City, MIN241TTTherrell G Tony · Kannapolis, NCN241VSDjd Aero Corp · Wilmington, DEN241VYShallbetter Joseph R · Marana, AZN241WFInternational Air Services Inc Trustee · Carson City, NVN241ZAlpha Tango Aircraft LLC · Wilmington, DEN24200Atp Aircraft 1 LLC · Wilmington, DEN24204Atp Aircraft 1 LLC · Wilmington, DEN24205Atp Aircraft 1 LLC · Wilmington, DEN24207Atp Aircraft 1 LLC · Wilmington, DEN2420LSasscer Michael Scott · Temecula, CAN24210Atp Aircraft 1 LLC · Wilmington, DEN24213Career Track 1 LLC · Wilmington, DEN24215Career Track 1 LLC · Wilmington, DEN24218Career Track 1 LLC · Wilmington, DEN24219Career Track 1 LLC · Wilmington, DEN2421RMerryman Todd K · Shickley, NEN2421WJohnston John · Sheboygan, WIN24221Career Track 1 LLC · Wilmington, DEN24222Career Track 1 LLC · Wilmington, DEN24223Career Track 1 LLC · Wilmington, DEN24226Career Track 1 LLC · Wilmington, DEN2422MGuyll Jay D · Denville, NJN2422UDennissan LLC · Noble, OKN2422YMarker Aviation LLC · Keller, TXN24236Career Track 1 LLC · Wilmington, DEN24237Career Track 1 LLC · Wilmington, DEN24238Career Track 1 LLC · Wilmington, DEN24239Career Track 1 LLC · Wilmington, DEN2423RAluminum Falcons Flying Club LLC · Bloomsburg, PAN2424Savage Bradley · Lac Du Flambeau, WIN24245Career Track 1 LLC · Wilmington, DE
Back to AD 2006-10-21