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.
N177AFMcgee Aviation LLC · Yorktown, VAN177AKBrockman Kenneth E Jr · Iliamna, AKN177AWFarni Edward C III · Billings, MTN177BCCraig William Richard · Vandalia, OHN177BGAccurso Steven M · Marietta, GAN177BHAircraft Trade Group LLC · Scandia, MNN177BLMontgomery David · Oak Park, ILN177BWRegistered aircraftN177CMRapid Cloud Aviation LLC · Waxhaw, NCN177CVZinkel Gregory S · Leander, TXN177DBarger Randall G · Newport News, VAN177DAParry Thomas J · White Post, VAN177DFAllen Douglas J · Fallbrook, CAN177DPPerkins Dimmitt J · Sheridan, ARN177EELiebeler Susan Trustee · Malibu, CAN177EJDouble A Flight Services LLC · Edinburg, TXN177ETThorstad Aviation LLC · Alexandria, MNN177FDSale Reported · Bowling Green, KYSale reportedN177FJInternational Air Services Inc Trustee · Carson City, NVN177FRLandrum David W · Hot Springs, ARN177GBHess Robert E · Rockford, ILN177GLRegistration Pending · Las Vegas, NVRegistration pendingN177GSAvco Patrol LLC · Lyndon, KSN177GTWoischke Robert B · Schaumburg, ILN177GWMarquette County Flying Club · Marquette, MIN177HCQualitair LLC Trustee · MichaelstadtN177HWCentral Virginia Aviation Inc · Petersburg, VAN177JFIsr Aviation LLC · Wilmington, DEN177JJJ P Jaeger Farms LLC · Imperial, NEN177JKRutsch Kirk A · Lewes, DEN177JLRisko Michael Robert · Sturgis, MIN177JMWright Alan L · Independence, ORN177JRIntelliray Inc · Decatur, INN177JTTefft John G · Exeter, NHN177KFBurnet Eddie S · Edmond, OKN177KRSeale Forrest D · Cherokee Village, ARN177LHPiper Aircraft Inc · Vero Beach, FLN177LJArnold James · Killeen, TXN177LSChav LLC · Pomona, KSN177MASouthern Aircraft Consultancy Inc Trustee · Casper, WYN177MGEngberg James C · Brimfield, MAN177MHHicks Charles Jr · Big Bear Lake, CAN177MPJones John K Jr · Shingletown, CAN177MSGilardi James D · Davis, CAN177PCJanney Tyson D · Fredericksburg, VAN177PLGunder Taylor · York, PAN177PMSale Reported · Cheyenne, WYSale reportedN177PSOvaert Daniel · Tryon, NCN177PWJones Bertha Ann Yates · Clinton, OKN177QFloyd Randy · Madison, AL
Back to AD 2006-10-21