AD 2000-22-18
Registered aircraft · 914
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-22-18')
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-22-18')
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-22-18') 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-22-18') 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.
N3622TShaw Aviation LLC · Greenleaf, IDN362DLBee Line LLC · Millwood, GAN36673Gta Air Inc · Addison, TXN3673RArtie Aircraft LLC · Trenton, MON3673UCastor Care LLC · Mount Pleasant, SCN3674GSudduth Ronald C · Lineville, ALN3681GRed Wolf Aviation LLC · Wilmington, DEN3682ZIliamna Air Taxi Inc · Iliamna, AKN368JEJones Enterprises · Nacogdoches, TXN3694LRegistered aircraftN3695NWalton Jerry Prince Jr · Monticello, FLN36AVCook Greg R · Willis, TXN36CTExecutive Mission LLC · Round Rock, TXN36TAN36ta LLC · Dover, DEN3701DN3701d LLC · Wilmington, NCN3707TFisher Kurt A · San Luis Obispo, CAN3711YAero Venture Lc · Shreveport, LAN3715BNova Jets USA Corp · Orlando, FLN3739BD & G Properties Troy LLC · Troy, ALN38020Pardue Hines Aviation LLC · Lincolnton, NCN3804ABig Love LLC · Tifton, GAN3806XTessec LLC · Cincinnati, OHN38089Dabbs Randal L · Lenoir City, TNN3809KGeneral Aviation Services LLC · Franklin, TNN3825XBliss Aviation LLC · Somerville, TNN3837WWardlay Farms And Ranches Inc · Grandview, TXN3867GW & S Aviation LLC · Fountain Inn, SCN3873BNpa Baron LLC · Gladewater, TXN3874YDavenport Henry B III · Charles Town, WVN38CEBrad Keener Dds Pa · Harrison, ARN38DZWoolard Flying Service Inc · Corning, ARN38TLBonanza 1 LLC · Hernando, MSN393FBRegistered aircraftN39HLCoastal Mobility LLC · Wilmington, NCN3MUAero Equities LLC · Ventura, CAN3PEJabr Aviation LLC · Milford, IAN401DRApex Aeronautical Group LLC · Jenks, OKN401SBGoertzen Joshua K · Wasilla, AKN403PAFergany Amr Farouk · Sebastian, FLN406PASale Reported · Rantoul, KSSale reported, canceledN407RSSiddens Tab D · Albany, MON40JBElk River Aero LLC · Noel, MON4108GKimberk Frederick S · Cambridge, MAN4108SBto Aviation LLC · Eden Prairie, MNN4115SDanielson Adam M · Chassell, MIN4124WGeaux Automotive Advertising LLC · La Place, LAN412DPickens Ray T · Pleasanton, TXN4130SYakish S Dale · Wexford, PAN414SWRmi Air LLC · Ocilla, GAN415LWWest Thomas Lee · Payson, AZ
Back to AD 2000-22-18