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.
N4983MMccray Todd · Saint Augustine, FLN4983ZKoerner Aviation Inc · Kankakee, ILN49848Linder Robert E Jr · Conway, ARN4984JBluewater Airmotive Corp · Wilmington, DEN4984RGingrich Fredric D II · Indianapolis, INN4984SLinair LLC · Lewes, DEN4984TBoggs Investments Air Div LLC · Fredericksburg, VAN4984ZRegistered aircraftN4985EAmar James E · Goodyear, AZN4985JEri-Aero Land Partners LLC · Flower Mound, TXN4985TPope Donald R · Enid, OKN49862California In Nice Inc · San Jose, CAN49864Purkinje Ltd LLC · Wilmington, DEN4986JMcelhiney Lance V · Harker Heights, TXN4986LFarrah Gabriel E · Avon, CTN4986VBlake Larry Q · Cleveland, GAN4986ZAlbers William J · Sidney, OHN49872Eaglet Flight Operations Lp · Fort Worth, TXN49878Sunrise Aviation Inc · Ormond Beach, FLN4987JFulco Jason E · Frisco, TXN4987NWhite Jake W · San Antonio, TXN49886Boon Bradley A · Greenwood, WIN4988HBent James L Jr DBA · Palatine Bridge, NYN4988LAnson Flyers Club Inc · Wadesboro, NCN4988SMosley Jerry · Las Vegas, NVN49899Sunrise Aviation Inc · Ormond Beach, FLN4989JEastern Florida State College · Cocoa, FLN498CCShephard Russell Steven · Gallatin, TNN498CFBosely Thomas L · Tavernier, FLN498CMRoberts Mark · Tecumseh, MIN498FLOneforty LLC · Dover, DEN498JBBriggs James D · Maryville, TNN498SPBmg Aviation Inc · Bloomington, INN498THInterstellar Vc LLC · New York, NYN4990DThompson Darrel D · Toronto, SDN4990JEstes Aviation LLC · Vicksburg, MSN4990LCc Aero Services LLC · Bullard, TXN4990PCrux Logistics & Consulting Ltd · Las Vegas, NVN4990UBoard Of Regents Of The University Of Oklahoma · Norman, OKN4990ZHanson Ethan C · Blanchard, NDN49916Clemence Richard · Southbridge, MAN4991LStrickland Sterling S · Sammamish, WAN4991NSage Daniel M · Girdwood, AKN4991TJohnson Aaron M · San Ramon, CAN4991ZSenneff James L · Clarence, NYN4992JBas Part Sales LLC · Greeley, CON4992LGrove City Aviation LLC · Mercer, PAN49931Monterey Bay Aviation Inc · Watsonville, CAN4993LEagerton Aviation LLC · Florence, SCN4993PHatch George R · Avon, MA
Back to AD 90-04-06 R1