AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N66GNMoye Brian C · Naples, FLN66GVPearson Robert L IV · Spartanburg, SCN66GZGarabedian John H · Southborough, MAN66HUUzzle Harry L · San Antonio, TXN66JFNaylor Matthew · Canyon Lake, TXN66JHHefner James L · Oro Valley, AZN66JJWilliams Nicholas Indrais · Pickerington, OHN66JMRussman Nicholas S · Farmersville, TXN66JSSisson Jp · Litchfield, ILN66KPRegistration Pending · Batesville, TXRegistration pendingN66KYKelcher Randi R · Saint Charles, MON66LKeating Gregory D · Carpenter, SDN66LGHarpenden Corp · Los Angeles, CAN66MACp Aviation · Santa Paula, CAN66MGPeeler Dixie L · Sandy, UTFirst renewal noticeN66MMTake Flyt LLC · Eagle Lake, MNN66MNGoebel Michael M · Conroe, TXN66MWWhidden Marion H · Okeechobee, FLN66NDMiller Aircraft Services Inc · Crookston, MNN66PArchangel One LLC · Lewes, DEN66PKMorton Dennis D · La Harpe, ILN66PMMajestic Air LLC · Lowell, MIN66PRPeterjohn Management II LLC · Pound Ridge, NYN66PSSaurenman Edward E · Southampton, NYN66PTRobin194 LLC · Prescott Valley, AZN66PWRegistered aircraftN66QMSammons Shaun W · Memphis, TNN66RDTiger Air 2 LLC · Atlanta, GAFirst renewal noticeN66SEDaubenberger Joseph R · Hood River, ORN66TPAmerican Aviation Aircraft Leasing Inc · El Cajon, CAN66TVDodson International Parts Inc · Rantoul, KSN66UNWillis Robert L · Havana, FLN66WEBurns Gregory A · Newnan, GAN66WHSix Six Whiskey Hotel LLC · Mount Vernon, KYN66WNMeyer Robert J · Canyon, TXN66WWWirstrom Michael N · Corrales, NMN66WYHedrick Kirby L · Cora, WYN66XCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN66XEFisher Michael A · Logan, UTN66XYRounds Nathan A · Zebulon, GAN66YEaa Aviation Foundation Inc · Oshkosh, WIN67000Registration Pending · Johns Island, SCRegistration pendingN6700CKelly Aviation & Investigation LLC · Vail, AZN6700FRunels Thomas L · Battle Creek, MIN6700HNashua Flyers Inc · Nashua, NHN67010Robinson Helicopter Company Inc · Torrance, CAN67013Del Ag Aero LLC · Milton, DEN6701JJones Bob J Trustee · Littleton, CON6701NFreeman Alan M · San Antonio, TXN6701RAirplane And Drone Flight Instruction LLC · Orlando, FL
Back to AD 90-04-06 R1