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.
N8937DBrunner Steve W · Mission Viejo, CAN8937VCowden Steven B · Bellingham, WAN8938FSouthern Cross Aviation Inc · Wilmington, DEN8938JMeier Daniel J · Greenwood, INN8938YUniversity Of Alaska Anchorage · Anchorage, AKN89390Nevill Jordan J · Ukiah, CAN89392Story John D · Harrah, OKN8939CRegistration Pending · Lakota, NDRegistration pendingN8939JEstis Jonathan D · Walden, NYN8939RJohnston James D · Tillamook, ORN893ACAri Ben Aviator Inc · Fort Pierce, FLN893ECMabry Dale C · San Antonio, TXN893FSSmith Francis H Jr · Lyons, CON893LTLamb James R · Hobe Sound, FLN893SHHowell 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, INN8942DCwynar 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, MNN8944Bundy John F · Hamilton, MTN8944FFitzgerald Brian B · Gettysburg, PAN8944YTallman 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, TXN8947RUpton Chris M · Hettinger, NDN8947VMills Alan F · Chatom, ALN8947YStroh Chuck · Yukon, OKN8948CKrupnik Amnon · Bethesda, MDN8948FO Reilly Thomas P · Oscoda, MIN8948JAlbright Frank E · Ashley, INN8948RWhomble Leonard L · Wray, CON8948VPlain Company Ltd · Bloomfield Hills, MI
Back to AD 90-04-06 R1