AD 2000-23-21
Registered aircraft · 47,133
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:2000-23-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:2000-23-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:2000-23-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:2000-23-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.
N361CWCk Aviation LLC · Brookhaven, MSN361DNeill James H · Keller, TXN361DMLeibstein Guy · Babylon, NYN361GCFff Leasing LLC · Dover, DEN361GMParody Luis C · Miami, FLN361JBCarroll Farm Management Company · Carthage, ILN361KMMclain Kevin A · Stoddard, WIN361KWFliteco Holdings LLC · Lewes, DEN361LBMiller Steven D · Edinburg, PAN361RDWellness Aviation LLC · Bradenton, FLN361SCShelton Jaime David · Hurricane, UTN361TA466m LLC · Evansville, INN361WHubbard Kenneth Scott · Decatur, ALN3621RBateman Randy · Lindale, TXN3621UStewart Gary T · Friendswood, TXN3621YRegistered aircraftN3622AWing Bird Aviation LLC · Garland, TXN3622TShaw Aviation LLC · Greenleaf, IDN3622UDegonia Gerald · Plainfield, ILN3624CMeadows Marcus M · Anchorage, AKN3624UWilkinson Larry G · Henderson, NVN3626YNb Ag Solutions Inc · Manila, ARN3627AHint Mart H · Peachtree City, GAN3627UStribling Tyron S · Lagrange, GAN3627YBarber Michael · Pagosa Springs, CON3629ADarrow Mark A Trustee · Mukilteo, WAN362ARegistered aircraftN362BSPro Leads Marketing LLC · Murrieta, CAN362CDBmg Adventures LLC · Decatur, TXN362CPLare Robert W Jr · Shreveport, LAN362CSJw Ttx LLC DBA · Indianapolis, INN362DBBb36 LLC · East Helena, MTN362DLBee Line LLC · Millwood, GAN362HEMidamerica Jet Inc · Owensboro, KYN362HPCaporale Ronald L · Dillon, MTN362JVBeaudoin Denis Roland · Rowlett, TXN362KWFliteco Holdings LLC · Lewes, DEN362MDJj Hughes Logistics LLC · Canyon, TXN362MMFly Second Wind LLC · Penn Yan, NYN362PC362 Papa Charlie LLC · Spokane, WAN362SBNilco Enterprises Inc · Irving, TXN362SRAviation Guys LLC · Charleston, WVN362TBarnett Blake C · Boynton Beach, FLN362ZKinder Jeffrey · Richland, WAN3630MAmercani Mahmoud · Fayetteville, GAN3631CClark Mark R · Pullman, WAN3631DMortgage Experts LLC · Homestead, FLN3631MTrekjet LLC · Southington, CTN3631UBurden Richard M · Woodway, TXN3632APauly Adam · Macomb, MI
Back to AD 2000-23-21