AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N733FAJr Imaging Logistics Inc · Pasco, WAN733FCKelley Aircraft LLC · Weyers Cave, VAN733FFRising Wings Aviation Inc · Casper, WYN733FGPnw Aircraft Holdings LLC · Issaquah, WAN733FNJls Aviation LLC DBA · Fredericksburg, VAN733FPSorbi Aviation Inc · El Cajon, CAN733FRCrotts Aircraft Service Inc · Dodge City, KSN733FSArbach Enterprises Inc · Watertown, SDN733FTRegistration Pending · Blaine, MNRegistration pendingN733FUSimplifly LLC · Mesa, AZN733FXCynthiana Flying Group Corp · Cynthiana, KYN733GBDouble Bridges Aviation LLC · Enterprise, ALN733GCWilliams Steve A · Tamms, ILN733GKHearn Richard J · Gardner, KSN733GLWhitewater Aviation Inc · Harrison, OHN733GMHansen Jens E · Arroyo Grande, CAN733GQMarc Aircraft Holding LLC · Soldotna, AKN733GSWings Over Texas Holdings LLC · Denton, TXN733GTSanchez Demolition Inc · Bosque, NMN733GVRiya Aviation LLC · Tracy, CAN733GXMarianas Air Transfer Inc · Saipan, MPN733GZRichardson Charley Mack II · Mount Pleasant, SCN733HAHuerta Holdings Inc · Santa Ana, CAN733HCWings Flight Enterprises Inc · Danville, KYN733HDFuqua Michael B · Chatham, VAN733HFVr Aerospace LLC · Seattle, WAN733HHThomas Ramone · Philadelphia, PAN733HJRegistration Pending · Bay Harbor Islands, FLRegistration pendingN733HKVan Anda Aviation LLC · Apopka, FLN733HNAriaprima LLC · Port Orange, FLN733HSSprague Daniel W · Roseburg, ORN733HTBrazos Valley Flight Services LLC · College Station, TXN733HUStoughton Trailers Inc · Stoughton, WIN733HZFranco Scott A · San Jose, CAN733JALakewood Investments LLC · Victorville, CAN733JCKrogh Michael L · Lees Summit, MON733JEHagerstown Flight School LLC · Hagerstown, MDN733JFJones Atticus · Salt Lake City, UTN733JHRiverside Flight Academy Inc · Riverside, CAN733JJJordan Scott A · East Falmouth, MAN733JLFordem Richard P Trustee · Borrego Springs, CAN733JMThunderbird Aviation LLC · Littleton, CON733JPMarc Aircraft Holding LLC · Soldotna, AKN733JSSchool Of Missionary Aviation Technology · Ionia, MIN733JTCl Habitat Management LLC · Salisbury, MDN733JWSeven 4 Zulu LLC · San Diego, CAN733KBGalion Air Inc · Galion, OHN733KEStettenbenz David A · Wasilla, AKN733KGNesher Aviation LLC · Jacksonville, FLN733KJGaffney John · Lauderhill, FL
Back to AD 81-18-04 R2