AD 80-25-07 R1
Registered aircraft · 25,369
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:80-25-07-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
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:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') 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.
N7180UTatum Brett A · Jones Creek, TXN7180VFlight International Corp Trustee · Santa Ana, CAN7181URegistration Pending · North Conway, NHRegistration pendingN7182GBar-Od-4 Cattle Co LLC · Laredo, TXN7182UFrasco Leonard · Cocoa Beach, FLN7182VAllen Paul · Altona, NYN7183QFlying Wild LLC · Yarmouth, MEN7183VRegistered aircraftN7184UColas Omari K · Dover, DEN7185GJones Mark R · Denton, MDN7185VKlopp Gary W · Houston, TXN7186UKay David Lloyd · Virginia Beach, VAN7186VKlein James V · Saint Cloud, FLN7187CWoldt Wayne E · Raymond, NEN7187QChestnut Ridge Flying Club · Latrobe, PAN7188CUniversity Of Kansas · Lawrence, KSN7188GVrechek Joseph D · Fort Lauderdale, FLN7188QToles Chad · Austin, TXFirst renewal noticeN7188UJones Kenyon S · Miami, FLN7188VCregan Daniel M · Webster, NYN7189GSky Hawk Flying Club · Grand Rapids, MNN7189QMontgomery Paul · Fredericksburg, VAN7189VGreat Miami Aviation LLC · Miamisburg, OHN718MJValiair Ltd Co Trustee · Casper, WYN718TETheis Timothy J · St Charles, ILN7190GM T Machinery Inc · Porter, TXN7190QEhc Group LLC · Franklin Lakes, NJN7191UDarrow Matthew J · Truckee, CAN7192QMansfield Heliflight Inc · Milton, VTN7193VArmbruster Jeffrey T · Norfolk, NEN7194GAvco Patrol LLC · Lyndon, KSN7194QOzarks Auto Show Inc · Hollister, MON7195GBurnside George C II · Hattiesburg, MSN7195QPuget Sound Flyers · Everett, WAN7195VScherer Eric · Mooresville, NCN7196QBurdis W J · Beaver Falls, PAN7197GFly Wissota LLC · Chippewa Falls, WIN7198GJones Lawrence A · St Simons Island, GAN7198QBay Lux Ventures LLC · Tampa, FLN7198VBrown Keane A · Portales, NMN719ACZing Aviation And Marine LLC · Edgewater, FLN719MWMel Williams Aviation LLC · Fairburn, GAN71BPPantaleo Robert · Vineland, NJN71CRSoto Arturo J · Laredo, TXN71GKMetsger J Grant · Granbury, TXN71HHEastern Slope Aviation Academy · North Conway, NHN71MKWyeth Patrick · Chino Valley, AZN71PKBob Hoover Academy · Salinas, CAN71SDRalph B Beatty LLC · Murrysville, PAN71WFRobins David M · Tehachapi, CA
Back to AD 80-25-07 R1