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.
N201ZZSky West Aviation Inc Trustee · Albuquerque, NMN20204Bellingham James G · Baltimore, MDN2020CN2020c LLC · Abilene, TXN20214Bingairman LLC · Newville, PAN2021CPray Aviation Inc · Augusta, KSN2021LNiehaus James O · Erie, CON2021RYergers Garage LLC · Leesport, PAN20223Roberts Stephen Wade · Friendswood, TXN2022CCarriere James M · Navarre, FLN2023RWhitehurst Brian P Trustee · Crossville, TNN2024CD M S Leasing Co LLC · Las Vegas, NVN2024EJoslyn Larry J · Las Vegas, NVN2024PYounhorsh Sales LLC · Wilmington, DEN2024RStorm David A · Lowell, ARN2024SRegistration Pending · Sublette, KSRegistration pendingN2026CSkys Aircraft Corp · Newnan, GAN20274Abc Flying Club Inc · West Mifflin, PAN2027PHake Equipment Leasing LLC · Farmington Hills, MIN2028RMurphy Kevin Adam · Douglas, GAN20296All Service Solutions Group Corp · Miami, FLN2029CAnderson Rebecca L · Fort Myers, FLN2029LNeff Michael J · Laveen, AZN2029USmith Thomas A Trustee · Rogersville, ALN202AJEnterprise Aviation Services LLC · Albuquerque, NMN202ASQualitair LLC Trustee · MichelstadtN202BBAkro Atttudes Inc · Lighthouse Point, FLN202BEKruse Stephan L Jr · Norridgewock, MEN202BKKucharski Bruce J · Pryor, OKN202BRRc Aviation LLC · Ladysmith, WIN202BWCoastal Defense Inc · Mill Hall, PAN202CBBrothers Aviation Va LLC · Manassas, VAN202CCJoslyn Larry J · Las Vegas, NVN202CEBarinowski Perry W · Appling, GAN202CGAvanti LLC · Louisville, KYN202CPCivil Air Patrol · Maxwell Afb, ALN202CRSt Louis Flying Club Inc · Ellisville, MON202CTIsrael Oscar M IV · Sinton, TXN202DSValiair Lc Trustee · Casper, WYN202ECRegistered aircraftN202EWExecutive Sales And Leasing LLC · Chetek, WIN202GESt Amant Mark S · Diamond Bar, CAN202GPRegistered aircraftRegistration pendingN202GTRenfro Michael W · Bethel, AKN202HSRadford William J · Bumpus Mills, TNN202JAAdams Toby R · Paris, TXN202JHPerrin Michel · Austin, TXN202LLieberman Alan M Trustee · Pleasanton, CAN202LSKsx Aviation Services LLC · San Francisco, CAN202MBaker Doug E · Tampico, ILN202MKMcminn Ronald K · Sequim, WA
Back to AD 2006-10-21