AD 73-25-01
Registered aircraft · 60
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:73-25-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-25-01')
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:73-25-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-25-01') 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.
N1011SAfrican American Airlines Inc · Brandon, FLN105MCMathison John M · Del Norte, CON10KMJohnson Walter N · Hico, TXN112HPBertagnole Karl R · Wright, WYN157CCWhite David W · South Fulton, TNN17UAce Flight LLC · Houma, LAN222FWLindsey Daniel Rey · Clovis, NMN234MWKuehn Kevin C · De Pere, WIN23JDraco Flight School Inc · Chino, CAN27ZZJohnson John C · Coeur D Alene, IDN411GCadwell Bradley L · Orlando, FLN4AS310 Air Ltd · Seville, OHN50GTThomas Richard E · Lafayette, TNN5330JTexas Airtime LLC · Fort Worth, TXN533GRocket Ride LLC · Yakima, WAN64310Aldrich Curtiss R · Big Oak Flat, CAN6PKBrest John E · Moses Lake, WAN777BWJones Gregory Noel · Waldorf, MDN777PMAccurate Aero LLC · Minden, NVN77MBCosgrove D DBA · Crestview, FLN8005MSmith Art · Dublin, CAN8006MKeesee Patrick L · The Villages, FLN8013MBas Part Sales LLC · Greeley, CON8014MCaldwell Machine & Gear Inc · Mount Pleasant, TXN8015MGill Conrad D · Mounds, OKN8030MInternational Air Services Inc Trustee · Carson City, NVN8036MObreiter Robert W Jr · Simi Valley, CAN8047MVertigo Aviation Inc · Lighthouse Point, FLN8050MPrice Earl · Audubon, PAN8055MHuffman Jacob M III · Burleson, TXN8056MHooper David M Trustee · South Jordan, UTN8060MBata Michael R · Port Orange, FLN8071MLand Sea And Air Inc · North Mankato, MNN8072MHigh Speed Flight Associates · Nickerson, KSN8073MRussell David L · Wasilla, AKN8081MHawk Hangars Corporation LLC · Jenks, OKN8083MUpshaw John L Jr · Claude, TXN8086MCaudell Michael A · Cleveland, GAN8097MNovember Sierra Aviation LLC · Oneill, NEN8103MCunningham Michael J · Great Falls, MTN8109MRegistered aircraftN8112MFiedler Allen J · Imperial, PAN8113MLansing Community College · Mason, MIN8116MJacobs Levon Jr · Oak Hill, FLN8118MRider Scott M · Beaverton, ORN8122MNo Slack Flyers LLC · Klamath Falls, ORN8139MAcme Racing LLC · Overland Park, KSN8141MTerry Jan Chester · Beverly Hills, FLN8147MDe La Rosa Sergio · Nogales, AZN8166MMagafly LLC · Bay City, MI
Back to AD 73-25-01