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.
N8939RJohnston James D · Tillamook, ORN893ACAri Ben Aviator Inc · Fort Pierce, FLN893AFAmeriflyers Of Texas Inc · Addison, TXN893CPCivil Air Patrol · Maxwell Afb, ALN893ECMabry Dale C · San Antonio, TXN893FSSmith Francis H Jr · Lyons, CON893LTLamb James R · Hobe Sound, FLN893NDUniversity Of North Dakota · Grand Forks, NDN893SHHowell Steven P · Oklahoma City, OKN894Blanton Aircraft Co Inc · Orlando, FLFirst renewal noticeN8940CDyda Wendy · Cassopolis, MIN8940JMullins David H · Zebulon, GAN8941DMain David W · Blounts Creek, NCN8941JTilghman Michael B · Salisbury, MDN8941RHamme Curtis S · Bedford, TXN8941VSky Castle Aviation LLC · New Castle, INN8941WSalisbury Airplane Associates Inc · Berlin, MDN8942DCwynar Scott L · Toledo, OHFirst renewal noticeN8942VPilots Flying School LLC · Englishtown, NJN89430Flabob Airport LLC · Jurupa Valley, CAN89433Chapel Hill Flying Club Inc · Sanford, NCN89438Sun Aircraft Management LLC · Ormond Beach, FLN8943JHuber Steven C · Hernando, MSN8943VZiegler Aviation LLC · Minneapolis, MNN8943WBlack Paul D · Auburn, CAN8944Bundy John F · Hamilton, MTN8944FFitzgerald Brian B · Gettysburg, PAN8944PPittner Hans C · Goshen, NYN8944YTallman Michael Daniel · Latrobe, PAN89456Czyzewski Justin · East Brunswick, NJN8945DSonnenberg Larry L · Huber Heights, OHN8945JFischer Thomas F · Troy, ILN8945RBehne Eric D · Brentwood, CAN8946Cox Paul Bartlett · Granbury, TXN89464Freeway Airport Inc · Mitchellville, MDN89469Hershberger David A · Unionville, INN8946CPilawski Darren J · Spring Hill, FLN8946J2mec Holdings LLC · Kalispell, MTN8946VWings Over Texas Holdings LLC · Denton, TXN8946WBeck Adam J · Mulberry, INN8947RUpton Chris M · Hettinger, NDN8947VMills Alan F · Chatom, ALN8947WWard Marcus K · Payette, IDN8947YStroh Chuck · Yukon, OKN8948CKrupnik Amnon · Bethesda, MDN8948FO Reilly Thomas P · Oscoda, MIN8948JAlbright Frank E · Ashley, INN8948RWhomble Leonard L · Wray, CON8948VPlain Company Ltd · Bloomfield Hills, MIN8948WGarrison Randy M · Plains, MT
Back to AD 81-18-04 R2