AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N42852Fisch Kurt D · Riverside, CAN42855Wojteczko Jason A · Derby, KSN4285HPralle Jeffory K · Wasilla, AKN4285QShielded Holdings LLC · Katy, TXN4285TBuenger Michael · Gilbert, AZN4285ZYoseph Barry L · Olympia, WAN42865Skylane Partners LLC · Duvall, WAN428663 Elm Terrace LLC · Waterville, MEN42867Burns Charles R · Huntsville, ALN4286PGress Gabrielle M · Davenport, FLN4286ZMalcolm Rodgers K Jr · Belzoni, MSN42871Registered aircraftN42874Kloker Daniel E · Owasso, OKN42875Bowes Tyler D · Fremont, OHN42876Norcal Flight Center LLC · Lincoln, CAN42877Allain Patrick C · Brusly, LAN42879Bartle Henry Trustee · Independence, ORN4287AWilliam Dolson And Associates LLC · Santa Fe, NMN4287JBillingsley Steven M · Prosperity, SCN4287QMonmouth Area Flying Club · Lakewood, NJN4287SLemanski Joseph S · Fiskdale, MAN4287TJonair LLC · Charleston, SCN4287ZCazac Connor · Kenai, AKN42885Sisca John A · Gilbert, AZN42887Bratlien Michael D · Aurora, CON42888Ahigian Craig S · Laguna Niguel, CAN42889Fuller Lawrence A · Wasilla, AKN4288HHoogendorn Homer E · Wasilla, AKN4288PMooradian Edward M · Fowler, CAN4288QN4288q LLC · Myrtle Beach, SCN4288ZAltobelli Matthew J · Dover, PAN42893Registration Pending · El Paso, TXRegistration pendingN42894Comal Aero Inc · Schertz, TXN42898Perera Austin L · Barnstable, MAN42899Smith Charles Max · Canon City, CON4289HGiguere Michael R · Danielson, CTN4289JMiller Curtis L · Brownstown, PAN4289THohm Harold C · Chicago, ILN428AJetpropmontana LLC · Cameron, MTN428ACMckinley Nathan C · New Braunfels, TXN428AKOlsen Martin G · Anchorage, AKN428BBPiper Aircraft Inc · Vero Beach, FLN428BLFlying Money Pit LLC · Des Moines, IAN428CPCivil Air Patrol Inc · Maxwell Afb, ALN428CTInda Trygve H · Sparks, NVN428DDJulius Donald D · Rollins, MTN428DKKugler Donald W Jr · Baptistown, NJN428DLGiair LLC · Morristown, TNN428DMCochran Michael S · Centennial, CON428DWArizona Cloudbusters Inc · Mesa, AZ
Back to AD 2007-04-19 R1