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.
N53895Stebbins Scott · Elk, WAN53896Clute Charles Sr · New Smyrna Beach, FLN53897Naca 130 LLC · Cameron Park, CAN53898Georgescu Paul F Jr · Carmel, INN5389HBlessum Jay A · Minot, NDN5389KMcconnell Cynthia D · New Smyrna Beach, FLN5389MChapel Hill Flying Club DBA · Sanford, NCN5389PJaehn Lawrence E · El Cajon, CAN5389QCieri Joe · Graves Mill, VAN5389WDumont Elizabeth M · College Station, TXN538CJav Air Services LLC · Anchorage, AKN538EELight Speed Air LLC · Los Angeles, CAN538EREmbry-Riddle Aeronautical University Inc · Prescott, AZN538HFSun Aircraft Management LLC · Ormond Beach, FLN538KSKent State University · Stow, OHN538LJessup Ervin L · Cape Girardeau, MOFirst renewal noticeN538MRArinder Jeffrey A · Peachtree City, GAN538NDAerosim Academy Inc · Sanford, FLN538PGSundstrom Steven L · Friendswood, TXN538SCSpartan Education LLC · Tulsa, OKN538SPRc Flying Partners LLC · Fair Oaks, CAN53900Nielsen Jeffrey A · Frankfort, MIN53901Aero Flight Dynamics LLC · Riverside, CAN53903Campbell Kasey W · Thornburg, VAN53904Sundblad Ryan M · Albert City, IAN53905Registered aircraftN53906Mock George M · Jackson, GAN53907Sakalaskas Jason · Fairbanks, AKN53909Rawlings Cecile Cole · Palatine, ILN5390HRidgway Rick J · Carlisle, INN5390LKnight Ronald J · Mesa, AZN5390PHankins Jon A · Fort Mohave, AZN5390VSpringfield Flying Service LLC · Columbia, CAN53912Rider R.P. Field · New Gloucester, MEN53914Kauzlarich Steve F · Oakland, CAN53918N53918 LLC · Charles City, IAN53919Alexander Aviation LLC · Brighton, CON5391HHansen Alvin Kent · Winamac, INN5391LMarchant Kenneth L · Indianola, OKN5391PWilliams Keith A · Pahrump, NVN53920Aero Dragger Ltd · Warminster, PAN53922Medford Pat G · Phoenix, AZN53923Little Dale E · Marshville, NCN5392HDeno Douglas · Battle Creek, MIN5392LYablon Brian M · Portland, ORN5392SBrickhouse Charles F · Wake Forest, NCN5392WCorbin Thomas D · Higley, AZN5392YJensen Jeff · Eagle River, AKN5392ZSteed Brian · Winnsboro, SCN5393HMacpherson Roni J · Cardiff By The Sea, CA
Back to AD 81-18-04 R2