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.
N75649New Horizons Aviation Inc · Goshen, INN7564DOtto Bryant C · Conway, ARN7564GRegistration Pending · Sterling, AKRegistration pendingN7564KCameron James T · Seldovia, AKN75650Strittmatter Joseph · Aubrey, TXN75651Hansen Robert Alan · Horseheads, NYN75655Doane Dale A · Moreland, GAN7565DSiegle Daniel L · Birdsboro, PAN7565GB&R Aircraft LLC · Wadsworth, OHN7565JSteffensen David J · Grimesland, NCN7565KReeder Don W · Rathdrum, IDN7565RKnox County Flying Club · Owls Head, MEN7565VRehwald William J S · Santa Monica, CAN7565WHurdle Scott R · Clemmons, NCN7565YVictor Robert W Jr · Topeka, KSN75668Allen Richard P · Southampton, NJN7566KHorseshoe Bar Land & Livestock LLC · Gillette, WYN7566PLambert Dwight E · Albany, ORN7566RHill Bruce W · Newton, ILN7566WStrobel Gary D · Mooresville, NCN7566YS & D Adventure LLC · Middletown, DEN75673Durner Charles L · Simla, CON7567FMansfield Heliflight Inc · Milton, VTN7567GWhipple Eugene B · Mchenry, ILN7567HGuidici Aidan G · San Antonio, TXN7567JFidelis Universal Technology Inc · Chino Hills, CAN7567PSteigerwalt Jeffrey A · Lehighton, PAN7567RThomas Baley B · Zavalla, TXFirst renewal noticeN7568FTranbarger Tad E · Macksville, KSN7568JRoberts Donald B · Albion, ILN7568VPawlish Andrew M · Fort Collins, CON7569DThiele Tamara L · Anchorage, AKN7569FMainero Tanner R · Chehalis, WAN7569GAirborne LLC · Wilmington, DEN7569HCompton Steven · East Northport, NYN7569PBrowne Donald K · Labelle, FLN7569VLiberty Capital LLC · Kalispell, MTN756AAtp Aircraft 6 LLC · Wilmington, DEN756AWLincoln Skyways Inc · Lincoln, CAN756DFFroster David C · Ravenna, MIN756GAtp Aircraft 9 LLC · Wilmington, DEN756WRegistered aircraftN75701Roseville Aviation LLC · Roxboro, NCN75704Lanning 1 Aviation LLC · Amarillo, TXN75706Morey Airplane Company Inc · Middleton, WIN75709Newsom Richard W · East Bend, NCN7570FReichelt Christopher M · Mocksville, NCN7570HSearles Lewis A Jr · Grafton, OHN7570JHubbard David L · Earlville, ILN7570KStrub Henry J · Dillingham, AK
Back to AD 90-04-06 R1