AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N184NWNorthwestern Michigan College · Traverse City, MIN184PHEbhs LLC · Monroe, MIN184PYCoggin Patric D · Fort Smith, ARN184RBBeverly Raymond E · Eugene, ORN184RFGreens Effects Inc · Moorpark, CAN184RJFarmer Gary W · Mount Juliet, TNN184RMPumpkin Seed Aviation LLC · Wilmington, DEN184SCChristiansen Robert S · Rapid City, SDN184SHSilverhawk Aviation Academy LLC · Caldwell, IDN184TSpaur Charles W · Aurora, CON184TCTexas State Technical College · Waco, TXN184TSSanders David M · Midlothian, VAN184TWEvans William Patterson II · Dallas, TXN1850NSnohomish Flying Service Inc · Snohomish, WAN18510Moore Jack B · Irvine, CAN18516Maine Instrument Flight · Augusta, MEN18518Sale Reported · Waterbury, CTSale reportedN1851APlacer County Sheriffs Department · Auburn, CAN18523Km50 Ventures LLC · Pensacola, FLN18529Briers Scott Kevin · Conroe, TXN1855PBpdk LLC · Mason, MIN18576Cardinal-Bird LLC · Melbourne, FLN1857RNoetic Aviation LLC · Seattle, WAN1858JKoenig Darrell Lee · Sumter, SCN1859AAverett University · Danville, VAN1859UMustang Sally Aviation LLC · Camden, SCN185ACFulton Lanny G · Spartanburg, SCN185CPCivil Air Patrol · Maxwell Afb, ALN185DCWood Ronal D Jr · Clarksville, FLN185LHPiper Aircraft Inc · Vero Beach, FLN185LYAwesome Classics LLC · Kalispell, MTN185WEChain Daniel · Lake Havasu City, AZN186Sold Now Development LLC · Boca Raton, FLN18602Poston James M · Hixson, TNN1860HNighthawks Sanity LLC · Chesterfield, MON1861GKestrel Aviation LLC · Marion, MTN1861HElusive Aviation Inc · Pflugerville, TXN1862HKaufman Keith · Reading, PAN18643Registered aircraftN-number assigned, not yet registeredN1866JAnderson Dale · West Jordan, UTN1866SAviation Addiction LLC · Fishers, INN1868Barber Mark E · Shady Cove, ORN18694Hughes Randall L · Post Falls, IDN1869RHarwood John · Waxahachie, TXN186ACHartman James R Trustee · Everett, WAN186BPBearhawk Demo LLC · Fairview, OKN186CPCivil Air Patrol · Maxwell Afb, ALN186CSFlying Rock Aero LLC · Sunnyvale, CAN186DTBell Michael · Cameron Park, CAN186FSBuck Michael A · Spring Branch, TX
Back to AD 2006-10-21