AD 2000-05-23
Registered aircraft · 144
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-05-23')
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-05-23')
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-05-23') 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-05-23') 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.
N550AHHall Aircraft · Wynne, ARN550KGSheffield Flying Service LLC · Iron City, GAN550PHHall Aircraft · Wynne, ARN550VAKingrey William S III · Richmond, TXN5539DThree Five Julier LLC · Winamac, INN562XChorman Spraying LLC · Milton, DEN6052BPacific Valley Aviation Inc · Arbuckle, CAN6096YKlein Flying Service Inc · Lawrenceville, ILN6117XFarm & Ranch Aerial Service Inc · Wharton, TXN61230Ag Solutions LLC · Garden City, KSN61252Shelton Agri Services Inc · Hereford, TXN6127LAg Solutions LLC · Satanta, KSN6133XBixenman Colleen R · Colby, KSN6136ZAg Solutions LLC · Satanta, KSN61374Hinkle Airspray Inc · Cavalier, NDN6203DField & Farm Aviation LLC · Hawkinsville, GAN6207GBank Of Utah Trustee · Salt Lake City, UTN62139A-T Rental Properties LLC · Tivoli, TXN6215MGrant County Mosquito Control District #1 · Moses Lake, WAN630LLCroom Aviation LLC · Port Saint Joe, FLN64DQLongwood Flying Service Inc · Hollandale, MSN655TATommys Flying Service Inc · Sherrill, ARN70009A-T Rental Properties LLC · Tivoli, TXN7003QLowry Flying Service Inc · Grinnell, IAN7005BSky Force Travel LLC · Jamestown, NDN7008MLongwood Flying Service Inc · Hollandale, MSN7013FWimberly Lane W · Cochran, GAN701TVVaughns Flying Service Inc · Reese, MIN70224Agricair Leasing LLC · Bancroft, WIN7022FTommys Flying Service Inc · Sherrill, ARN7024JSchindler Flying Inc · Neligh, NEN70WYBecker Flying Service Inc · Hartington, NEN751WCValley Spraying Service LLC · Gann Valley, SDN753WCPrecision Air Tactics LLC · Welton, AZN760BFHeritage Ag LLC · Lakeview, MIN763BFMountain Air Spray Co Inc · Craig, CON773CCGlenn Air Inc · Palmer, AKN909FSMj Aviation Inc · Walnut Ridge, ARN915HAHeritage Ag LLC · Lakeview, MIN92JASouther Field Aviation Inc · Americus, GAN986MMGarrett Flying Service Inc · Danbury, TXN9899Registered aircraftN995MCCaprock Spraying Inc · Vega, TXN995MGBecker Flying Service Inc · Hartington, NE
Back to AD 2000-05-23