AD 75-09-13
Registered aircraft · 4,787
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:75-09-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
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:75-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13') 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.
N3761PSky Rollers LLC · Merritt Island, FLN37676Campbell & Associates Investment Properties LLC · Burleson, TXN376RHSeckel Dean · Mount Vernon, WAN377CFCohen Rolando S · New York, NYN377JS270 Aviation LLC · Elizabethtown, KYN378SStarr William E · Eagle River, AKN3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIN3796GSantos Aviation LLC · Chico, CAN3799PCt Services LLC · Albuquerque, NMN37EWKundel Andrew R · Muscatine, IAN37GMCraft Engineering Associates Inc · Hampton, VAN37JKSsr LLC · Incline Village, NVN37PB37pb Inc · Seattle, WAN37PMRegistered aircraftN37RZOwens Martin · Telluride, CON37UJet Set Aircraft Inc · Van Nuys, CAN37VMVictory Maximus LLC · Dublin, OHN3801CDanuser Aviation LLC · Fulton, MON3802JDental Surgical Center Of Medina Inc · Medina, OHN3802NDiehl Donald L · Garden City, KSN38040Mosier Daniel J · Tucson, AZN38049Moore Aviation Services LLC · San Antonio, TXN3804MGlenmont Air LLC · Strasburg, VAN3807TAmbrose Construction Ltd · Corpus Christi, TXN3807XAlpha Bravo Lima LLC · Covington, TNN38082Pope Bill F · Prescott Valley, AZN3810CBlake Thomas C · Vero Beach, FLN3813QBemowski Paul · Madison, WIN3817MGulf Skies LLC · Kalispell, MTN381DSFlightpath Investments LLC · Ottumwa, IAN381TCShumate Frank T · Rockport, TXN3820LFly A Twin LLC · Kirkland, WAN3822KPerry Park Investments Inc · Larkspur, CON3829PRalphs Thomas A · Solana Beach, CAN382CRSkyport Aviation LLC · Oxford, MIN382MCShiver James B · Stanley, NMN3839RChad Gunter Enterprises LLC · Albany, GAN3839SBailey Glenn K · Englewood, CON383SA86 Malibu LLC · Fort Worth, TXN3840YBurrill Resources Inc · Medford, ORN3841GWhetzel Michael L · Ukiah, CAN3842UBezet Danny · Comfort, TXN3842YCole Scott A · Rockford, MIN3843SSky West Aviation Inc Trustee · Albuquerque, NMN3848YBaron Lake LLC · Jefferson, LAN384AMHaggard Haley G · Springer, OKN3850GN3850g LLC · Stamford, CTN3854GDry Creek Aviation LLC · Belmont, CAN385CAHyannis Air Service Inc · Hyannis, MAN385RAdvanced Technology Distributors Inc · Ceres, CA
Back to AD 75-09-13