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.
N2252LEaton David B Jr · Leicester, MAN2252USkylake Adventures LLC · Geneva, OHN2252ZBerman Rayanne S · Hatfield, PAN2253LFisher Robert C · Shepherdstown, WVN2254URaritan Valley Flying School · Princeton, NJN2255JDaves Jeffrey · Sebastian, FLN2256SGuttzeit Aviation LLC · Baton Rouge, LAN2257RCanales Jorge · Anthony, NMN2257UMurray Richard A · Celina, OHN2259LVelte Jerrid · Grand Haven, MIN2259UMyrtle William E · Martinsville, INN225ABMinden Soaring Club Inc · Minden, NVN225ACSafeflight Alliance Inc · Osprey, FLN225AKSkywagon Ventures LLC · Chapel Hill, NCN225BCMontague Ronnie L · French Camp, MSN225CBCalifornia Baptist University · Riverside, CAN225CENothing By Chance LLC · Jackson Hole, WYN225CLFalcon Air LLC · Casper, WYN225CTRicketts James B G · Portland, ORN225CZTaylor Stephen Marklew · State College, PAN225ESKermanj Sohrab · Port Saint Lucie, FLN225FAMcclure Nicholas W · Midland, TXN225FGMeridian Aircraft LLC · Wilmington, DEN225FTSerrino Sam · Youngstown, OHN225HMSmithart Eric W · San Juan, PRN225JACoffin Paul · Sioux City, IAN225JPBrazos River Aviation Group LLC · Mineral Wells, TXN225KLMeridian Aircraft LLC · Wilmington, DEN225KTAnselmetti Federico · Miami, FLFirst renewal noticeN225KYAtb Inc Trustee · Wilmington, DEN225MCP46 Tango LLC · Friday Harbor, WAN225MLSeaton Flying Services · Killeen, TXN225NTLattin Travis W · Beloit, KSN225RARochester Air Center LLC · Canandaigua, NYN225RSMeridian Aircraft LLC · Wilmington, DEN225SFAb Prop Plane I LLC · Metairie, LAN225SGWilliams Stephen W · Granbury, TXN225TBHot Wings Aviation LLC · Indianapolis, INN225TFTop Flight Aviation Inc · Corona, CAN225THMariner John M · Houston, TXN225TMSouth Of Snow Adventures LLC · Hartwell, GAN225TVBuell Travis · Harper, TXN225WCBozeman Skyhawk LLC · Bozeman, MTN225WM225wm Aircraft Leasing LLC · Spanish Fork, UTN225WSSpartan Education LLC · Tulsa, OKN225YWhite Wings LLC · Anchorage, AKN225ZMoe Kevin · West Chester, OHN2260TOrtner Airport LLC · Wakeman, OHN2261NLehrman Ronald L · Brownsburg, INN2261QAndrews University · Berrien Springs, MI
Back to AD 2006-10-21