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.
N7777DMorris Blain E · Delta Junction, AKN7777HSale Reported · Jennings, LASale reportedN7777KMoss Conrad C · South Pittsburg, TNN7777PWeihe Philip D · Cleveland Heights, OHN7777WAmmon Roadable Aircraft LLC · Manchester, NHN7777YDigati Anthony J · Mentone, CAN7778Carpenter Darrell W · Midland City, ALN7778BPeters Ben C · Leavenworth, WAN7778MFlorida Best Airlines LLC · North Miami Beach, FLN7778NAsari Investments LLC · Knoxville, TNN7778YSpiegel Eitan · San Francisco, CAN7778ZIglehart Stephen R · Bismarck, NDN7779CDicey Aviation LLC · Somerset, KYN7779DEssman Kenneth R · Burlington, WIN7779HRenfro Jacqueline L · Bethel, AKN7779JLehrkamp Mike C · Caputa, SDN7779NPhyxsius Aviation LLC · El Paso, TXN7779WHolowatsch Sergio O · Archer, FLN7779YMccool Kenneth W · Olive Branch, MSN777AHJarhead Aviation LLC · Port Saint Lucie, FLN777BBMrnak Andy M · Bowman, NDN777CCJohnston Steven M · Lyle, WAN777CRRhodes Curt W · Reno, NVN777CYMiller Shawn C · Milaca, MNN777DJMartin Dale A · Lewiston, IDN777DPArnold Vincent Craig · Rosharon, TXN777DTMcchristian Jerome M · Granbury, TXN777DUSc Infinities LLC · Dover, DEN777DVTharp Thomas J · Nampa, IDN777DWLawless Aviation LLC · Fishers, INN777EEDga Aviation LLC · Sacramento, CAN777ENSky West Aviation Inc Trustee · Albuquerque, NMN777ESD&J Aviation LLC · Gotha, FLN777EZInternational Aviation Group LLC · Lake Wales, FLN777FJStewart Michael W · Snellville, GAN777FMBolduc John A · Port Saint Lucie, FLN777FSCasey William F · Ponderay, IDN777GC777gc Holdings LLC · Milford, CTN777GEAir Float One LLC · Stuart, FLN777HJBallantyne Benjamin J · South China, MEN777HVSkyline Air Tours LLC · Crown Point, INN777HYRohr Aviation LLC · Centennial, CON777JRMiloud Chadd K · Fort Worth, TXN777KBGeisler Stephanie N · Inman, SCN777KGLonnevik Dennis F · Bigfork, MTN777KPKelly'S Flying Service LLC · Warrensburg, MON777LCSelover Stephan Holger A · Lake Oswego, ORN777LFAeolian Corp · Wilmington, DEN777LH7 Moon LLC · Albuquerque, NMN777LKMathena Gregory H · Guilford, IN
Back to AD 81-18-04 R2