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.
N4520RBurge John A · Pensacola, FLN4520TBrummell Colten Andrew · Hannibal, MON45210Domogala David J · Southbury, CTN45211Beloit Aviators LLC · Jefferson, WIN4521C4 Legged Fliers LLC · Brick, NJN4521JSpringer Louis A · Bellflower, CAN4521LCarey Daniel · Rockville Centre, NYN4521NMehraban Seyed Habib · Los Angeles, CAN4521RLenz Gregory K · Everton, MON4521TSpencer Kevin L DBA · Bend, ORN4521VPirri Anthony N · East Falmouth, MAN4521XClemmons Philip B · Madison, ALN4521ZWeichert Eric S · Janesville, MNN45223Moran Timothy P · Acworth, GAN45226Gildersleeve Robert · Storrs, CTN4522ABryant Stephen · Anchorage, AKN4522BKlifman Dustin · Muskegon, MIN4522LGaines Charles C · Fernandina, FLN4522NFrieling Judson D · Houston, TXN4522XBlack Rain Inc · Wilmington, DEN4522ZCandeletti James · Forked River, NJN4523CShelton Agri Services Inc · Hereford, TXN4523DFalk Thomas M · Silver Spring, MDN4523JN4523j LLC · Wilmington, DEN4523RGardner Michael J · Ashland, ILN45240Buford Thomas Edwin · Lemoore, CAN45248Lewis Steven A · Mesa, AZN45249Porus Joseph B · Oakland, NJN4524BBarbero Matias J · Cape Coral, FLN4524EHarper Michael B · Buena Vista, CON4524KMorris David R · Montara, CAN4524NHorejsi Michael E · Castro Valley, CAN4524PRegistered aircraftN4524QRegistered aircraftN4524WRichardson Shane D · Pekin, ILN4524XSharp Jacob · El Paso, TXN4524ZMercer Eric S · Ukiah, CAN45250Thiele Klaus U · San Diego, CAN45253Dewey Alice · West Palm Beach, FLN4525BCmis N4525b LLC · Carlsbad, CAN4525CBeauchard Lucine E · Morehead City, NCN4525FStallknecht William A · San Antonio, TXN4525GMcdonald James O · Hulett, WYN4525L525 Lima Corp · Grayslake, ILN4525NClavey Sean P · Port Orange, FLN4525RFreiberg Industries Inc · State Center, IAFirst renewal noticeN4525UBenedict Co LLC · Maryville, TNN4525WHamilton Kevin Michael · Lake Charles, LAN4525YGorham James A · Mandan, NDN4525ZPadilla Jesse · Fremont, CA
Back to AD 90-04-06 R1