AD 2000-23-21
Registered aircraft · 47,142
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.
N1354ESandra And Mose Rucker III LLC · Perrineville, NJN1354ZGallo 12 LLC · Kalispell, MTN1355CC&E Aviation LLC · Kalispell, MTN1355SFlight Services Limited LLC · Bennett, CON1355ZEnns Nathan G · Shafter, CAN1356MYbarra Xavier · Uvalde, TXN1356STc Aviation LLC · Atlanta, GAN1357SSmith & Smith Inc · Hurricane, WVN1357ZBromschwig Eric I · Montgomery, TXFirst renewal noticeN1358CBrad Influence Llp · Wahpeton, NDN1359GEaglehead Aviation LLC · Tifton, GAN1359MJtal Holdings LLC · Wilmington, DEN135ANegative Ghost Rider LLC · Bangor, MEN135ABShreds Aircraft LLC · Pittsburgh, PAN135BEJeff Proctor Holding Lc · Park City, UTN135BWSteier James M · Omaha, NEN135CDFaast LLC · Sparks, NVN135CEBell Strategic Investments Inc · Escondido, CAN135DGSg Solutions LLC · Reno, NVN135DMHarris Michael G · Spokane, WAN135DTDelta Tango Aviation LLC · Salt Lake City, UTN135DWWagner Dennis L · Zionsville, INN135FPointon Aviation LLC · Baraboo, WIN135FBSky West Aviation Inc Trustee · Albuquerque, NMN135JAD & K Aviation Inc · Milford, IAN135JT878ys LLC · Kalispell, MTN135KCHerndon Cliffton R · Youngsville, NCN135KDSkylight Aviation Corp Trustee · Wilmington, DEN135MGOld Crow LLC · Columbus, OHN135MPDudjak Investments Group LLC · Sugar Land, TXN135NCBalocco Mark E · Sparks, NVN135PXBmaf LLC · Lewes, DEN135RPValiair Lc Trustee · Casper, WYN135RRMorse-Ellington Bruce P · Phoenix, MDN135RWOneal Eric T · Geneva, FLN135SRGunnin Larry · Simpsonville, SCN135TBToth Richard Day · Thurmont, MDN135TTAircruise LLC · Hobbs, NMN135USJohn Hale · Temple, TXN135VBPriori Holdings Inc · Jacksonville, FLN135WWKarwowski Richard · Battle Ground, WAN1360CPinnacle Aviation LLC · Valdosta, GAN1360LKoukol Orin Trustee · Sacramento, CAN1361QLannigan Anthony Robert · Tucson, AZN1361VLeduc Richard · Mazama, WAN1362APochwatka Patryk · Treasure Island, FLN1362FOldham Kris D · Anchorage, AKN1362TKcon Airplane LLC · Kalispell, MTN1363SAlabama Law Enforcement Agency · Montgomery, ALN1363ZMccune William D · Tehachapi, CA
Back to AD 2000-23-21