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.
N9631LNonemaker Joseph R · Quakertown, PAN9631MOrvin Sanden Inc · Wyndmere, NDN9631PKansas Air LLC · Linn, KSN9631QHuntsman Ferral Don · Juneau, AKN9631RBw Flying Association · Seattle, WAN9631SFreedom Aviation Of America LLC · Newcastle, TXN9631UCross Scott · Scott Township, PAN9631VHarrold Bruce E · Greybull, WYN9632HSweitz-Air Inc · Stewartstown, PAN9632JAirbrain Aviation Inc · Snellville, GAN9632MAvimar · Marina Del Rey, CAN9632UArmstrong Michael · Indianapolis, INN9633HWings Over Texas Holdings LLC · Denton, TXN9633LKessler Garry A · Lansing, WVN9633MGould Zachary · Pleasant Hill, MON9633UMoseley Warren C · Haslet, TXN9633WFladager Enterprises Inc · Peerless, MTN9634DBacklund Scott W · Greybull, WYN9634K137 Lynwood LLC · Elmira Heights, NYN9634LBeach Donald R · Atlanta, GAN9634MBig Sky Flying Inc · Napa, CAN9634QDubois County Flight Services Inc · Huntingburg, INN9634WShinar Philip C · California City, CAN9635BFisher Frank L · San Diego, CAN9635HArizona Aircraft Leasing LLC · Mesa, AZN9635KN9635k LLC · San Luis Obispo, CAN9635LAcme Club Training Inc · Anchorage, AKN9635MN9635m LLC · Cumming, GAN9635QRozynski Jason K · Malabar, FLN9635SPake Bradley P · Felton, MNN9635UCarmichael Donald L · Carlisle, INN9635V35 Victor LLC · Decatur, GAN9635WGordon David · Long Branch, NJN9636HMontanez Orlando · Guaynabo, PRN9636JPorter Julia N · Pflugerville, TXN9636LWest Main Auto Sales Inc · Tupelo, MSN9636MBistline Leland K · Fredonia, AZN9636RTrans West Specialties · Visalia, CAN9636USchroeder Wolf Udo · Rochester, NYN9636VNaperville Flying Club · Woodridge, ILN9637DSpivey Harold E · Thomaston, GAN9637QWingsleasing LLC · Wichita, KSN9638CJones Francis P Jr · Newport, ARN9638HHatbright Farm LLC · Wilmington, DEN9638JPrince Jennifer R · Farr West, UTN9638MPinheiro Rodrigo P · Albuquerque, NMN9638QPeterson John E · Benton, KSN9638VCrazy Aces LLC · St George, UTN9639CNichols Brian J · Mount Hope, WIN9639DVestal James L · Kernersville, NC
Back to AD 81-18-04 R2