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.
N8924RMachler Lance J · Murphys, CAN8924VDupree Johnny · Crossett, ARN8924YPrestininzi Robert Anthony · Fort Mill, SCN8925FAztec Aviation · Geneseo, ILN8925YBlue Sky Adventures LLC · Hanover, PAN8926Johnson David H · Jasper, GAN8926DPlanes & Things Inc · Collinsville, OKN8926JGreene Ronald F · Mc Alpin, FLN8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLN89273Anderson Ben H · Fort Smith, ARN8927JTipton Thomas G · Walnut Grove, MON8927PSmith Tracy L · Middletown, CTN8927VTropical Aviation LLC · Gulf Shores, ALN8928Anding Jay B · Bryan, TXN8928CGiber Kristofor D · Manvel, TXN8928FDenver Aerospace Science Museum · Watkins, CON8928JHaybron David M · Sewickley, PAN8928MKeyt Jeffrey D · New Providence, NJN8929Cavanagh James B · Litchfield Park, AZN8929JRice Spencer F · Portland, ORN8929LPeters Nicholas J · Eagle River, AKN892ACAri Ben Aviator Inc · Fort Pierce, FLN892DLBd Aviation LLC · Sauget, ILN892PTTims Duane R · Hemet, CAN892SGCraik Evelyn June · Las Vegas, NVN893012265 LLC · Mercer Island, WAN8930DBeverly Lester E · Shepherd, TXN8930JMccracken Blake R · Lake Havasu City, AZN8930MCuratola Bruce J · League City, TXN89310Kuyl Marinus D · Forest Grove, ORN89312Hillsboro Aero Academy LLC · Hillsboro, ORN8931VAeroventures 8 LLC · Mt Carmel, TNN8932DRegistration Pending · Caldwell, IDRegistration pendingN8932MOlivieri Michael R · Wasilla, AKN8932VEverett William M · Tuscumbia, ALN8932YStrohmeyer Gregory C · Wasilla, AKN89333Chapel Hill Flying Club Inc DBA · Sanford, NCN89337Davis Andrea E · Lake Oswego, ORN8933DGrandy Leland P · Rock Springs, WYN8933JQuilling John R · Cannon Falls, MNN8933LDuncan Aviation Inc · Lincoln, NEN8933RThrall Gregory D · Seward, AKN8934CHandel Patrick A · Wautoma, WIN8934VUniversal Aviators Academy Inc · El Monte, CAN8934YFuller John M · Minden, NVN89358Redstone Arsenal Flying Activity · Redstone Arsenal, ALN89359Mccartney Robert · Mountain View, CAN8936JCloud Niners Inc · Brownsburg, INN89372Rodriguez Devin · Arlington, TXN89377Bishops' Ltd · Virginia Beach, VA
Back to AD 90-04-06 R1