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.
N264FAStratus Rr LLC · New Castle, DEN264JSAllen James M · Gilmanton, NHN264MCAir Mc Inc Trustee · Wilmington, DEN264ME618 Aviation LLC · Kosse, TXN264MGGeorgia Aviation Authority · Eastman, GAN264NSKelley Shawn J · Cottage Grove, ORN264RHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLN264SFAb Prop Plane I LLC · Metairie, LAN264WYMcgowan Bruce Trustee · Solvang, CAN264XWignall Fred J · Newcastle, WYN26502Bugsmasher Aviation LLC · Benton, KSN26504Vista Aviation Inc · Pacoima, CAN26509Bell Air LLC · Belleville, KSN2650VSampson Merle A · Inver Grove Height, MNN2650WBrown Danny L · Wichita, KSN2651RAtls Aviation LLC · Stuart, FLN2651WStolworthy Spencer D · Maple Valley, WAN2652THart William · West Plains, MON2652WRegistered aircraftN2653TValley Aircraft Restoration Society Inc · Phoenix, AZN2653WDyer Perri P · Argyle, TXN2654ZAlbij3 LLC · Milton, FLN2656CHgta Partners LLC · Grand Rapids, MIN2656GAtp Aircraft 4 LLC · Wilmington, DEN2656ZChesebro Brian S · Oro Valley, AZN2657WRegistered aircraftN2658CMay Jeffrey P · Seligman, AZN2658TLoer Stanley W · Grants Pass, ORN2658WPerez Dennys · Orlando, FLN2659TLeja Surveying Corp · Yucaipa, CAN2659WMooney Flyer LLC · Belton, SCN265AAWhitten Chris K · Alton, MON265ATAirline Transport Professionals Corp Of USA · Wilmington, DEN265CAZacherl Randall L · Indiana, PAN265FAStratus Rr LLC · New Castle, DEN265HBBarrow Guy J · Loveland, CON265MATrevathan Max Tyler · Braggadocio, MON265MESunset Leasing Inc · Sarasota, FLN265MGGeorgia Aviation Authority · Eastman, GAN265MHHarrington Michael · Twin Falls, IDN265PLAdams Aviation Services Inc Trustee · Wilmington, DEN265SFAb Prop Plane I LLC · Metairie, LAN265TWYale Companies LLC DBA · Indianapolis, INN265WGelinas Peter L · Burien, WAN265WYGemini Aviation LLC · Holmdel, NJN2660QSummit Aviation LLC · Spokane, WAN2660WDeptula John R · Pinehurst, NCN26613Coomes Thomas R · Hollis, OKN26616Sea Wing LLC · Camarillo, CAN2661TSix One Tango LLC · Pismo Beach, CA
Back to AD 2006-10-21